WoW view for multiple measures

[cshetty]

I am looking to create a WoW view for several measures together within my report. I reviewed the periodOverPeriodDifference function but I don’t think it fits my use case as I want to derive this difference across multiple measures. Below is an example of the report i am trying to prepare

                          Week 1    Week 2   Week 3  WoW (Wk 3 - Wk 2)

Total applicants
Lead time
Measure 3
Measure 4
.
…
…

[Max]

Have you looked into table calculations?

You would still need to do it for every value.

[cshetty]

Thank you for the response. the above recommendation worked. however, now there is an empty column prior to the WoW column that I cannot hide, same for the row headers (attached image). Is there a workaround for this?

[Max]

Unfortunately this is a limitation of quicksight.

There are previous feature requests for this issue, but I can mark it again.

Thanks!