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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
date | Date | The month to compare with the previous month. |