YoY Monthly/Quarterly Growth Graph in QS

Hello!

Is there a way to plot the Month/Quarter (based on period type selected by the user) on a horizontal line chart to see YoY trends in metrics? Something like the image below. Where instead of plotting month and year on the x-axis, we only have Month or Quarter. Thank you!

Currently, I’m able to get the previous value using the lag function but it is tied to the same time period so I’m unable to plot it as a graph. The layoutworks as a pivot to see previous value and % difference but there are too many numbers.

image

I would take a look at this post! It should have everything you are looking for!

2 Likes

Thank you for the quick response!