Period Over Period Dashboard
The Period Over Period Dashboard shows the difference in a selected measure between two periods. This helps you assess the most recent status of any financial or volume measure and compare its performance to the same time period in the past.
Set Up Data and Filters
For this dashboard you can set the following inputs:
Input | Description |
---|---|
Customer(s) | Allows you to choose one of customer attributes to be used for the analysis. Displayed only when Customer data is used in the package ( Keep in mind that only columns present in the Transaction Datamart can be used for filtering. |
Product(s) | Allows you to choose one of product attributes to be used for the analysis. Keep in mind that only columns present in the Transaction Datamart can be used for filtering. |
Measure Type | Allows you to define the measure type for further measure selection. Available values:
|
Scale Change Bars as % | Affects whether the Change series in the chart is displayed as an absolute value or as a relative one (Actual Measure Column as % of Comparison Period). |
Display Z Axis | Affects whether the Change series in the chart are equipped with a separate Z axis using its own scale or whether it uses a common Y axis shared with the Actual Measure Column and Comparison Period series. |
Interval Size | Defines the time granularity of the displayed output. Available values:
When Interval Size changes, values of Number Of Intervals and Offset of Comparison Period input are automatically converted to respect the scope of the original Interval Size. |
Number of Intervals | Allows you to set the length of the period (e.g. 12 months, 4 quarters). |
Offset of Comparison Period in [Intervals] | Defines how many intervals (i.e. days, weeks, months, etc.) the Comparison Period should go backwards from the end of the Actual Period (i.e. measured from the Final Interval). |
Final Interval | Defines the end of the Actual (most recent) period (e.g. a specific month, quarter or year). Available values are:
|
Include Impact Period | Allows you to highlight a specific portion of your chart and get detailed information displayed for it under the chart. For details see how to read the results.
|
Currency | Allows you to choose the currency used in the dashboard. The exchange rate for the selected currency is fetched from the system |
Generic Filter | Allows you to set up a generic transaction data filter. For example: display only data from Europe, or Asia. |
Analyze Results
This chart shows the difference in a selected measure between two periods. This provides you with data to assess the most recent status of any financial or volume measure and compare its performance to the same time period in the past.
The selected measure is compared using the Actual Period and Prior Period lines (both of the same length); difference between these two is shown using red/green change bars. For further analysis, you can also use Impact Period which provides more details on a selected part of your chart.
The granularity of the periods (days, weeks, months, etc.) is defined in Interval Size.
Chart Series | Description |
---|---|
Actual Period (blue solid line) | Typically the most recent period. Its duration is defined using the inputs Final Interval and Number Of Intervals, as described here. |
Comparison Period (orange dashed line) | A period in the past which you want to compare with the Actual Period. |
Change bars | Difference between Actual Period and Comparison Period. The bars show the progress of the selected measure:
|
Impact Period | Represents a portion of the Actual Period for which you get detailed data. Using Impact Period is helpful for further analysis of a specified part of the chart without having to leave this screen. Once the Impact Period is defined, you get:
|
Field Definitions and Used Advanced Configuration Fields
To learn about field definitions and used advanced configuration fields, see Period Over Period Dashboard (Technical User Reference).