Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

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

Learn More

View all

Sign in to view all badges

Calculate Month over Month Delta in a Table

Avatar

Avatar
Validate 1
Level 1
gitaib7122029
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
gitaib7122029
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
gitaib7122029
Level 1

22-03-2019

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:

   

MonthVisitorsMoM Delta
January1344
February234574.5%
March276718.0%
April9879257.0%
May1341-86.4%
June3452157.4%

Anyone know how to make that happen?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

129 likes

Total Posts

334 posts

Correct Reply

144 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

129 likes

Total Posts

334 posts

Correct Reply

144 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

24-03-2019

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:

1718169_pastedImage_9.png

1718170_pastedImage_16.png

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

1718177_pastedImage_17.png

Week over Week

1718178_pastedImage_22.png

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

Answers (0)