Good morning!
I've been asked for a dashboard with ticket sales by month for two different years Oct-Aug. Is there a way to make the months in my column chart show up starting in October? I figured out how to get them to start in January, or in alpha order, but I can't wrap my brain around starting on a specific month.
Thanks!Anne
Hi Anne,
If you use the ORDER DATE Months in Date field on Rows or Categories for your widget, and also filter on that field to Months Oct-22 through Aug-23, then the months will display in order. You can also change the displayed Month description in the widget from 10-2022 to October if you like.
Then with a ticket sales value in place, duplicate the value and from the options for that value select Quick Functions > Past Value > Past Year, which will render the ticket sales for any given month in the widget, but from 1 year prior.
Thanks, Chris! This is an issue that has plagued me as well. Happy to have this solution in my toolbox. I added in seasons in an attempt to explain the complexity of having multiple seasons on sale in the same month. I'm not sure if it comes across...but it makes sense to me.