ExecutiveSummary
Query a summary of changes between a month and the previous month
Table Specific Information
SELECT
A date may be provided when querying this view. If it is not provided, then this report will compare the current month with the previous month.
Columns
| Name | Type | Description |
| Metric | String | The value that is being compared between months |
| ThisMonth | Decimal | The value of the metric at this month |
| PreviousMonth | Decimal | The value of the metric at the previous month |
| Variance | Decimal | The percent difference between the previous month and this month. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |
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 | Date | The month to compare with the previous month. |