How to arrive week on week % growth over previous week

Question & Answer
,
1

Hi all,

Trying to arrive % growth over previous week % achd, couldn’t able to get through . can any help me in getting the support.

sample snapshot

image
image1303×232 9.86 KB

1 Like
2

Hi @sbaskax - you can use the period over period function as highlighted in the documentation below:

https://docs.aws.amazon.com/quicksight/latest/user/period-over-period-function.html

1 Like
3

Hi @SD_QS ,

I am looking to arrive WOW % growth over previous week’s % achd (calculated field)
I couldn’t able to use Period over period computation. may i know how to overcome

4

@sbaskax please see the attached screenshot. In the example, Profit% is a calculated column: sum(Profit)/sum(Sales) and “PoP Change in Profit%” is WOW% change using the following formula: periodOverPeriodPercentDifference({Profit%}, {Order Date})

I hope this works for you. Do let us know if you’re facing any particular issue.

image
image1028×167 8.65 KB

5

@SD_QS ,

I tried as your suggestion , but i am getting syntax error. in my dataset column week is in integer. i assume this could be the issue.

image
image1002×201 6.83 KB

6

@sbaskax yes please use a column of Date type and see if the issue persists

1 Like
7

@SD_QS ,

My dataset don’t have date column,for some other calculation/visualization iam maintaining week in integer datatype…

any suggestion to overcome in this datatype itself