How to do Wow calculation

Question & Answer
, ,
1

I have a table as below… I want to represent the same in QuickSight but in QuickSight I don’t know how to calculate wow… I want to calculate wow for the latest two weeks… other weeks should Remain same…

image
image3024×4032 5.69 MB

2

Hi @Aani - Please confirm whether week0,week1,week2,week3 are columns of the data set. In that case you can create a calculated field and do this calculation. Please find the documentation to create a calculation field -Adding calculated fields - Amazon QuickSight

Give a try, if you are facing any issues, let us know.

Regards - Sanjeeb

3

So my column names are week and competitors… so how to create a calculated field based on these two columns which will show wow

4

Can someone help me with this ?

5

Hi @Aani - Please follow the below steps.

  1. Create a calculated field called WOW with below logic.
(({week04} - {week03})/{week04}) * 100

See the sample data, in my case i take week4 and week3 for calculation.

image
image1195×685 56.1 KB

Regards - Sanjeeb

6

Hi Sanjeeb, I understand the explanation but in my case next week it will be different … next week it would be week 4 and week 5. So each week I can’t create a calculated value … need it to be calculated automatically

7

Hi @Aani - are you saying each week your file layout will be changed? Then it is very difficult to create something generic. Can we have a column called Week_No and then it may have value like 1,2,3,4 and then corresponding values will be there in another column?

I believe the column should be fixed first, then we can think of some generic formula.

Hi @Max @David_Wong - Kindly provide your feedback on the same?

Regards - Sanjeeb

8

@Aani this won’t be possible in Excel either as there is no information in the dataset about the last 2 weeks…

this might be possible if the week number becomes the value,

Product   |  Week     | Value
Aaple     |      0    |    1
Aaple     |      2    |    1
Aaple     |      3    |    4

then you might be able to use one of these functions and build your wow formula using
rolling{calculation}, level aware calculation, and rank

1 Like