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.
How are weeks counted in Analytical Designer?
Analytical Designer counts weeks according to the ISO 8601 week-based calendar where Week 1 is always the week with the first Thursday in January.
When you compare your data to the same period last year, weeks may not have the same dates.
|Week 1||December 31, 2018 - January 4, 2019||December 30, 2019 - January 5, 2020|
|Week 25||June 17 - June 23||June 15 - June 21|
Why can't I apply comparison to some insights?
- Some inisight types do not allow comparison. To use comparison, switch to another insight type.
- Calculated measures that are created from measures already created in Analytical Designer cannot be compared.
For details, see Create Calculated Measures in Insights.
- The date filter must have the same dimension as one of the date attributes in your insight.
For details, see Pivot Tables.
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
If you compare your data to previous period with a static interval and view your data by date, you must now use the day granularity.
The data for previous period are calculated and displayed based on the actual number of days in the original period. Grouping the data, for example, by month may spread the data over more groups and may not match the displayed granularity.
If you do not have weeks available, see Enable Weeks in Date Filters.