Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Percent Change Calculation

Avatar

Level 1

11/19/18

I would like to see a % change calculation - or summary change calculation - across multiple metrics. Right now, we can do this across a single metric, but I'd like to be

able to do this MoM for example. In the screenshot included below, I'd love to include a % change column that runs down the right-hand side to show the change MoM across each device type I've pulled into the table.

Percent Change Calculation.jpg

5 Comments

Avatar

Community Advisor

12/7/19

just right-click in the header column and select "show change to previous month". if that doesn't work you can create a calculated metric on your own.

Avatar

Level 1

1/4/23

I believe the option 'Compare Time Periods' (the one that creates a % comparison) is only available if you create a precise Date Rage (like the one in the pic e.g .Oct 1, 2021 - Oct 31, 2021), and it has to be on top of a Metric (as it shows in the pic, it is on top of 'Visits'). 

If you are using generic data ranges like 'Last Month', 'This Month' or even 'Oct 2021', I don't think it works.. 

allangaigher_1-1672832001671.png