Calculating WoW

[khkr999]

Hey
I would like some guidance in calculating the WoW in a calculated field
The calculation of the WoW will be (Week28-Week27)/Week28
Please note that the value (effectiveness ) is a calculated measure
and will not allow nested aggregation.

[Kellie_Burton]

Hi @khkr999 -
The PoP functions in QuickSight require aggregated metrics - see the blog post to walk thru multiple use cases. If you have other requirements due to the way effectiveness is calculated, please share more details.

Best Regards,
Kellie