14 Replies Latest reply on Feb 7, 2017 3:49 AM by Lucie Brett

    Automating the axis month order to change start month to current month - 8

    Lucie Brett

      Hello everyone,


      I have searched the forum to see if I can find the answer to my question but haven't been able to  work this out myself.


      I currently want to compare enquiry cycles, I use the calculated field "Cycles" to assign time periods into cycles (don't want to include too far back and I want the cycles to start at 8 months ago).


      The problem is now that each month I have to change the order of the month axis so that it starts at current month - 8 e.g. May appears first, I have 16 charts like this and so it is time consuming.


      Can anyone think of a way to automate the order of the month axis so that it updates each month?


      Thanks so much in advance, Lucie