KPI
Key performance indicator metrics.
View Specific Information
Select
The provider will use the Act! CRM API to process WHERE clause conditions built with the following column and operator. GroupName is required to make a request and the rest of the filter is executed client-side within the provider.
- GroupName supports the '=' operator.
- Start supports the '=' operator.
- End supports the '=' operator.
The provider processes other filters client-side within the provider. For example, the following queries are processed server side:
SELECT * FROM KPI WHERE GroupName = 'Opportunities'
Columns
| Name | Type | Description |
| Label | String | The label of the KPI metric. |
| Value | Decimal | The value of the KPI metric. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| GroupName | String | The KPI group name to retrieve. Required. |
| Start | Datetime | The start date-time for the analytics date-time range. |
| End | Datetime | The end date-time for the analytics date-time range. |