Compare of Compare
What it is:
Compare of Compare (CoC): This mode allows you to compare 2 waterfalls. The secondary waterfall is defined by turning Compare of Compare on (in settings) and then defining the start of your secondary waterfall (Start_CoC) and the end of your secondary waterfall (End_CoC)
In the backstage, DataMa will then run the same analysis for the 2 definitions of start and end, and then display the results of the secondary analysis in the background. Main output is :
- In the Waterfall « Chart », the secondary waterfall is displayed in the background
- In the Executive summary, the trend between secondary and primary analysis will be worded
When to use it
Compare of Compare mode is particularly useful when you run regularly the same analysis for different periods of time.
We can take the example of this dataset.
You’re in Week 3 2019, and you want to compare to Week 3 2018. Using DataMa Compare, you get this:
Now, the real question that you’re asking when you run this every week (so you ran this also in week 2) is: how is that different from last week?
This is where you activate Compare of Compare, and add Week 2 YoY analysis as secondary waterfall (yes, this assumes you also kept week 2 in the source you’re analysing).
And here are the results: