• Replies 5 replies
  • Subscribers 701 subscribers
  • Views 100 views
  • Users 0 members are here
Options
Related

Showing months beginning with a specific month

Anne M Robichaux
$organization

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

Parents
  • $organization

    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. 

     

Reply
  • $organization

    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. 

     

Children