Month over Month % Change

ryanalbanamazon · January 3, 2023, 11:28pm

Hi All - looking for help on how to do what’s in the title. Here are my data points in a bar chart, looking to add a line showing % change month by month. Can’t seem to figure it out - any ideas?

I have a date field, and a sum(field) basically - thanks!

mateoleon210 · January 4, 2023, 5:55am

You can achieve this by using the PeriodOverPeriod functions on calculated fields. Here is the documentation: periodOverPeriodDifference - Amazon QuickSight

sagmukhe · January 4, 2023, 6:26am

Hello @ryanalbanamazon - Happy New Year! You can try to create a calculated field using the periodOverPeriodPercentDifference function. Please see the below calculation and snapshot for your reference. Hope this helps!

periodOverPeriodPercentDifference(sum(Sales), {Order Date}, MONTH, 1)

ryanalbanamazon · January 4, 2023, 9:20pm

When I add this as a line, my visual goes blank and this error pops up

ryanalbanamazon · January 4, 2023, 9:21pm

Can you check my error below? That’s what happened when I added as a line - ty!

Koushik_Muthanna · February 3, 2023, 8:28am

Hi @ryanalbanamazon

Are you still facing this issue ? . Could you validate if column is of datatype date ? .
Also if I understand this correctly, you are seeing this error in the analysis.

Regards,
Koushik