StageTime
Generates opportunity data for the average time in a stage.
Table Specific Information
Select
The connector will use the Act! CRM API to process WHERE clause conditions built with the following column and operator.
- Date supports the '=,>,<,>=,<=' operators.
- StageId supports the '=' operator.
The connector processes other filters client-side within the connector. For example, the following queries are processed server side:
SELECT * FROM StageTime
Columns
| Name | Type | Description |
| AvgDays | Integer | Average Days |
| StageName | String | Stage Name |
| StageId | String | Stage Id |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Date | Datetime | Date Range of Activities By User |