Visualize four months data in pivot and MoM for lastest two months

Question & Answer
, ,
1

I am trying to visualize data for past four months, and show MoM for lastest two months. I saw this thread: MoM calculation variations but there was no update on it. I am trying to figure out how I can achieve this look:

image
image1309×67 4.47 KB

@duncan

1 Like
2

Hey Mariam,

to show the data for the past four months you can use Date Parameters: Setting up parameters in Amazon QuickSight - Amazon QuickSight
and for the MoM difference you could use the PeriodOverPeriodDifference: periodOverPeriodDifference - Amazon QuickSight with an offset of 1 month.

Hopefully this can help you

BR
Robert

1 Like
3

Hey @Mariam !

I agree with @robert.eibers , those two suggestions should set you on the right track.

1 Like
6

Hey @Mariam !

Were you able to try @robert.eibers suggestion above, and if it worked could you mark their comment as the solution?

7

Hi @duncan Unfortunately I am unable to visualize it using the above. It gives me difference for all the months creating a column next to every month. I am looking for difference for last two months, and then more formulas based on that field.

8

Hey @Mariam !

To achieve your example above I would suggest using a table visual because the pivot table will want to group the columns, and in my experience it has been easier to use the table visual for this type of use case.

You will need to create new columns for the months that you want to display, and if you want those to be dynamic, you could create parameters to determine their value. So you would have calculated field that you would look like this:
sumIf(sum({Sales}), {Order Date} = ${MonthParam})

9

Hey @Mariam !

Were you able to try my suggestion above or did you find another solution?