How to build dynamic calculation for WOW, MOM, YOY, and QOQ calculation on the basis of date parameter?

Question & Answer
, , ,
1

Hi Everyone,
Is there a way to build dynamic WOW, MOM, QOQ, YOY calculation on the basis of date parameter? For eg: If I change the date parameter to Monthly then, the dashboard shows Monthly data and %MOM diff metric and when I change it to weekly, the dashboard shows weekly data and WOW metrics in the dashboard. Thanks!

2

Hi @saljain
you can check out the blog to get familiar with the calculation.

To bring it into one visual you can create a calculated field , that checks the granularity and will give you the right calculation.
BR

3

Hello @saljain !

Was @ErikG 's suggestion helpful in solving this problem, and if so could you mark their comment as a solution?

It has been a few days since we have heard from you but would still like to help you find a solution!

4

Hello @saljain!

It has been a few days since we have heard from you but would still like to help find a solution. For now I am going to mark @ErikG 's comment as the solution.

If you still need help with this please reach out in the community, and you can link back to this topic.