My blog has moved to jimdehner.com
Thank you for all the support over the past 2 years - I recently updated my blog to make it easier to read, improve the rendering of images and tie back to video presentations that are associated with the content - Check it out at Jim's new blog -
Hello, Jim Thanks for this awesome tip. I was wondering if this can be possible using parameters and customizing the calculations for quarters instead of years? So, I'd like the user to pick their comparison quarters - Say 19Q1 vs. 18Q2 and the resulting viz would be the customized QoQ change? Thanks much.
ReplyDeleteHi
ReplyDeleteThanks for the question - the solutions here use real calendar dates and you should be able to do a QoQ analysis - if you are using FY then see https://jimdehner2.blogspot.com/2020/10/faq-series-fiscal-date.html on this blog and if 19Q1 etc are strings first convert them to real dates - see https://jimdehner2.blogspot.com/2020/06/faq-series-convert-string-dates.html -