Illustrate YoY Growth Rates and hide original values

[Xclipse]

Hello @helu

Welcome to the community! Thanks for your question!

To calculate and display the growth metric YoY, QoQ, MoM in Amazon QuickSight.

Please refer the below documentation and community posts this might be helpful for you.

How to calculate YOY % through certain date?

Hello, I am trying to get to a certain YOY value, and think there is an easier way to get to it than I am thinking. I am a Power BI user so I am trying to just ‘transfer’ the same logic from Power BI to QuickSight. I need to display YOY %s in a KPI visual up to a certain date. I have the correct formula to find the YOY % each month for rolling 12 months, but since I have a bunch of blank values prior to the last 12 months, QuickSight is treating these as 0’s and incorrectly skewing my total YO…

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…

YoY% , MoM% and QoQ% calculation for numeric month and year values

Hi Kellie, thanks for checking on this. The periodOverPeriodPercentDifference() is working for YoY% differences but I am trying to find out the MoM% and QoQ% differences between the latest 2 months and latest 2 quarters in the dataset respectively. The output should look something like the MoM and QoQ columns in the screenshot. [image]