 Level 1

0% to Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

SOLVED

## Calculate Month over Month Delta in a Table  Level 1

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?

1 Accepted 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

2 Replies  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  Level 2
I created the formula, but I am not able to use the sort_by. I have everything, but that. How do I add the sort_by?  