cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zpaul_010 Regular Visitor
Regular Visitor

Sort date on Line chart

my data is composed of reports with create time and closed time ranging Dec 2017-July 2018 (this is just a sample data). 

When I plot them using Created date by Month, it shows this. 

Capture.JPG

This was sorted by monthnumber column (jan is 1, Feb is 2, etc. ).  As you can see, December was included where it should not because its dec 2017. If I add my older reports, im afraid that Nov 2017, Oct 2017 and so on will be ploted on the same line. 

 

I thought, numbering all months by number (jan 2015 as 1, Jan 2017 as 25) but I'd like to know if there's a better way. 

 

Any ideas?

1 REPLY 1
Community Support Team
Community Support Team

Re: Sort date on Line chart

Hi @zpaul_010,

 

Is it possible to add the "Year" onto X-axis together with "Month"? If not, I think the only way is to add an extra order column with numbers (jan 2015 as 1, Jan 2017 as 25). Then, change the default sort by option for Month column.

 

Regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.