How to display Week over Week (WoW) result dynamically?

Question & Answer
, ,
1

I have used the PeriodOverPeriodDifference function for the WoW Compliance calcucation.
WoW Compliance Calculation: periodOverPeriodDifference(Compliance,{week_of},DAY,7)
But the result only shows on one level in the Pivot table. In my case, WoW compliance results show on station level. If I collapse the table to the region level, WoW value disappears. I don’t know the reason, is it possible to show WoW value in all levels.

WoW_Calculation
WoW_Calculation1976×1465 169 KB

2

This is because some contain null values.

Can you try and filter out the stations that have null compliance and see if you get a WoW Compliance then?

3

Hi Max,

Thanks for your quick response. I refreshed data and the region I am testing which all stations have values. I format data of value to 0 as well. But when I collapse the table to the region level, WoW value still doesn’t show up.
If I remove the station from rows, I can see WoW value on the region level. Is it related to the function?

WoW_Calculation_StationLevel_RegionLevel
WoW_Calculation_StationLevel_RegionLevel1886×2190 256 KB

4

Hello @Li_Yang !

I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new QuickSight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our QuickSight experts. Thank you!