ExecutiveSummary
Provides a summary of the changes between a given month and the previous month. It allows quick analysis of financial changes in income, expenses, and key performance indicators.
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 specific value or performance indicator that is being tracked and compared across time periods. This could represent a financial metric, sales figure, or any key performance indicator (KPI) relevant to the business. |
| ThisMonth | Decimal | The value of the metric for the current month. This represents the measurement of the metric for the most recent period (current month), allowing for analysis of the current performance. |
| PreviousMonth | Decimal | The value of the metric for the previous month. This represents the measurement of the metric for the month immediately preceding the current month, providing a point of comparison. |
| Variance | Decimal | The percentage difference between the current month's metric and the previous month's metric. This value indicates the relative change in the metric between the two periods, highlighting trends or fluctuations. |
| TenantId | String | The unique identifier for the tenant, allowing the query to access data specific to a particular tenant in a multi-tenant environment. This ensures that data is queried from the correct tenant's environment. |
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 date representing the current month being compared to the previous month. This field allows users to specify the month they want to analyze and compare against the previous month's data. |