How to calculate Week on Week growth in quicksight? I have 5 metrics which are calculated field and added in “Values” field and pivoted as rows. then “country” is added in “Row” field. Week number in column filtered for past 6 weeks. Now we need the WoW calculation in the last column for each metric
Hi @krtse - Welcome to the community. Have you looked into creating a calculated field using periodOverPeriodDifference ? You can use this function for WoW calculation and use that calculated field in your visual.
Yes @awsvig , I have used but it is not allowing me to put it under COULUMN field and saying custom aggregate field is not allowed as a dimension.
@krtse – Aah ok. Custom aggregate calculated fields like periodOverPeriodDifference can only be used in the “Values” field, not as dimensions like “Column” or “Row”. The dimensions need to be existing fields from your dataset.
Hi @krtse,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!