Hi All,
I’m trying to build a QS dashboard and I’m stuck at calculating the MoM. I’m trying to replicate the dashboard from tableau to QS and I’m just stuck at MoM calculations for last 2 months based on the control. I kinda played around with the table calculations and calculated field but I could not find a way. Can you let me know the best way to do this?
I’m quite new to QS and would really appreciate your help! Thanks in advance
Thanks for the post. I’ve gone through the posts but i haven’t been able to find something for my usecase. I have used table calculations to get the MoM for all the measures in a single column but i don’t know how to remove/hide the previous month column. Is that possible or is there a better way possible?
So you want to show in the table only the “current” month (e.g. Apr 2020) with the quantity and MoM?
If you are using simple periodOverPeriodDifference(sum(quantity),{transaction_date},MONTH,1) you need the Mar 2020 as calculation reference. As soon as you filter (focus on Apr 2020) you will not get a MoM result.
Yes. I want to achieve the format in the first pic that i shared. I basically want the trailing 4 months from the date the user chooses and the MoM column for last 2 months.
I shared the second pic just to see if there is a way to hide the last month column so that i can put that visual beside the trailing 4 months visual.
I am looking for something like this- 4 trailing months from the reporting date and MoM. Thanks!
@abreddyk are you still running into this problem or were you able to find find a solution? Or was @ErikG’s response helpful in finding a solution? If so could you post your workaround to help the community or mark one of the comments above as the solution?
