Issue with the KPI

[akashmanjunatha123]

Hi Guys,

I am using the KPI viz to show the YOY and MOM and Q1 over Q2,
here MOM works perfectly fine but presently we are 2023 and aug month, i cant show YOY for this year coz i have only 8 months KIP obviously shows negative, how to add condition in such a way that if the year completes only display YOY and same wrt the quarter?

[Max]

Hi @akashmanjunatha123

This article should help you out.

Creating period comparisons with QuickSight's periodOver and periodTo functions

This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

Specifically the KPI portion and YTD.

[Asem]

Hi @akashmanjunatha123 ,
Did Max’s suggestion help? I’ll mark it as a solution, but please feel free to let us know if you need further assistance.

thank you.