I have created one dashboard to show one metric at weekly basis, using pivot table in Quicksight.
I would want to add the metric improvement percentage:
improvement% = [metric(WeekN) - metric (WeekN-1)]/metric (WeekN-1)
How to add improvement percentage calculation field?
How to write correct syntax to showcase the improvement% in the pivot table?
— [Is there any possible to create a dropdown while selecting the week number then the improvement% can be automatically reflected?]