I'm trying to create a calculated metric that will allow me to show a running MoM delta in a workspace. It would look like the third column below:
Month | Visitors | MoM Delta |
January | 1344 | |
February | 2345 | 74.5% |
March | 2767 | 18.0% |
April | 9879 | 257.0% |
May | 1341 | -86.4% |
June | 3452 | 157.4% |
Anyone know how to make that happen?
Solved! Go to Solution.
Here is what I would do to create a calculated metrics for Visit % Month Over Month Delta :
Calculated Metrics Summary:
(Visit - ((function Cumulative (number 2 metric Visit sort_by ascending_sort true) - function Cumulative (number 1 metric Visit sort_by ascending_sort true)))) / ((function Cumulative (number 2 metric Visit sort_by ascending_sort true) - function Cumulative (number 1 metric Visit sort_by ascending_sort true)))
Note: Replace "visit" with any desired metrics above to visualize % Month Over Month Delta for the chosen metric.
Snapshot:
WorkSpace Table:
You can use any time dimension to calculate % delta in place of the month (weeks, days etc.). The metric will auto adjusts the calculation for the applied time dimension.
Month over Month
Week over Week
QA:
See summary change for highlighted week/month with the corresponding week/month row value. % delta value should match with it. See snapshot above.
Thanks,
Asheesh
Here is what I would do to create a calculated metrics for Visit % Month Over Month Delta :
Calculated Metrics Summary:
(Visit - ((function Cumulative (number 2 metric Visit sort_by ascending_sort true) - function Cumulative (number 1 metric Visit sort_by ascending_sort true)))) / ((function Cumulative (number 2 metric Visit sort_by ascending_sort true) - function Cumulative (number 1 metric Visit sort_by ascending_sort true)))
Note: Replace "visit" with any desired metrics above to visualize % Month Over Month Delta for the chosen metric.
Snapshot:
WorkSpace Table:
You can use any time dimension to calculate % delta in place of the month (weeks, days etc.). The metric will auto adjusts the calculation for the applied time dimension.
Month over Month
Week over Week
QA:
See summary change for highlighted week/month with the corresponding week/month row value. % delta value should match with it. See snapshot above.
Thanks,
Asheesh
Anyone with a follow-up on this? I can't see "sort_by" either.
I created the formula without the sort_by or ascending_sort functions and it works great. I have only tested with day and month on unique visitors.
I wonder if you can make it so it doesn't matter what metric is placed? Is there such capability?
Views
Replies
Total Likes
Is there a way to do this for Year over Year as a calculated metric?
Views
Replies
Total Likes
Views
Likes
Replies