Illustrate YoY Growth Rates and hide original values

[helu]

How can I calculate a metric, based on last year’s & this year’s values, illustrated as growth as “(this year-last year)/last year” and only show the growth in the chart, hiding last year and this year 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]

[Xclipse]

Hi @helu

It’s been a while since we last heard from you, did you have any additional or follow up questions regarding your initial topic? Were you able to try out the approach that was shared?

If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution to close out the topic.

Thank you!

[Xclipse]

Hi @helu

Since we have not heard back from you with any further information or follow-up questions, I will archive this topic. If you still need assistance, please post a new question in the community and link to this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts.

Thank you!