In Analytical Designer, you can use the date filter for time over time comparison to analyze your data without using complex MAQL syntax.
You can use the compare feature in Analytical Designer for the most common scenarios. For complex comparisons, go to the Reports section. See Time over Time Comparison in Reports for details.
You can compare your data with:
Same period of the previous year
For example, you can display data for March 2018 and compare it to March 2017.
For example, if you filter data for March 21-30 and apply the Previous period comparison, Analytical Designer displays also your data for March 11-20.
If you set the date filter to All time, you cannot enable the comparison.
- In Analytical Designer, add Date to the Filters bar.
- Click the Date filter.
In the Compare the period with dropdown list, select Same period previous year or Previous period.
If you select All time in the Period dropdown, you cannot enable the comparison.
In the Apply on dropdown list, select measures that you want to compare and click Apply.
If you select All measures, the settings automatically apply to any new items that you add to the Measures section.
You can change the comparison only in Analytical Designer. On KPI Dashboards, you can change the period that the insight displays.
If you remove the original measure, the derived measure (previous period or same period previous year) and measures derived from it are also removed.
When you drag the original measure to the Data Catalog, Analytical Designer highlights all the measures to be removed and then displays a message.
How It Works
All items in the Measures section have dynamic sequence labels displayed in the top right corner of the item.
The sequence labels are floating. This means that the first item always has label M1, the second has M2, and so on. When you reorder the items, their label dynamically changes.
When you apply comparison, Analytical Designer creates new items in the Measures section.
These items are derived from the original items:
They are placed above the original item. Drag and drop to reorder them.
If a headline insight has only one measure, the derived item is placed in the other Measures section. If the headline has two measures, the insight compares the measure from Measure (primary) and places the derived item to the Measure (secondary) section.
- They have information from which measure they are derived.
- They have SP year ago or previous period added to their name. Click the name to rename them.
For details, see Rename Measures.
- They have the same formatting and the same filters applied as the original measures.
- When you delete the original item, the derived measure is deleted as well.
- When you delete the derived measure, the original item stays.
- You cannot add attribute filters and date filters to the derived items.
We recommend to not use a static date filter
When you slice your data by date and compare it to the previous period, be aware that the resulting slicing of the comparison always corresponds to the number of days of the original period. See the FAQs below.
Why do I see "Displaying only supported measures" when applying compare?
You cannot compare measures that have a date filter specified. Analytical Designer displays this message in the comparison dialog.
For information about date filters, see Filter Measures by Date.
Why can't I apply comparison to some insights?
Some insight types do not allow comparison. To use comparison, switch to another insight type.
Also, you cannot compare calculated arithmetic measures that are created from measures already created in Analytical Designer. For details, see Create Calculated Measures in Insights.
Why do I see "Unsupported measures and attributes are hidden" when I apply Time over time comparison?
Analytical Designer displays this message in scenarios such as:
- You apply comparison to an insight and then switch to another insight type that does not support comparison.
- You apply comparison to insights with Stack by/Segment by.
- You apply comparison to headlines with two measures.
Using comparison with previous period in combination with static date interval
We do not recommend using a static date interval with previous period comparison when the insight is viewed by date and grouped by month, quarter or year.
The data for previous periods are calculated and displayed based on the actual number of days in the original period. This can lead to a situation when the previous period is spread over more groups (for example, months) than the original period, and does not match the displayed granularity of the original period.