Custom month display in a graph

[siddhantk989]

Hi,

 I am trying to create a line graph between months of Fiscal date and sales. Now my fiscal date actually starts from October, so on the x axis of my line graph I want the months to start from October and not January. Is there any way to do that?

[Dog · Accepted solution]

you'll need to add an order calculated column into the table with the dates. 

typically in our dates table we have a Month of Year Column which holds a 1 for january, 2 for Feb etc... 

if you have this you can then add a calc column to store the order. 

=if([Month Of Year]-9<=0,[Month Of Year]+12-9,[Month Of Year]-9)

you can then set the order by column on any referenced date columns (so your fiscal date column) to newly created order by column. 

I hope that makes sense.