cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allav Frequent Visitor
Frequent Visitor

Sort by month (9,10,11..) & year (2018, 2019..)

Hello,

 

I have a dashboard with tables and charts in my visualization which are connected to a table which has seperate columns for months and years. the months are indicated as numbers.

I had the months of 9, 10, 11, 12 of 2018 and now am adding also 1 of 2019 which is now causing me issues with sorting as this january comes first.

in my table and charts I add the month into the visualization and sort by it. then I tried to add the year field into the tooltip and sort by it (as a secondary sort)... this doesn't work

I hope someone here could have a better idea for me

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Nolock Established Member
Established Member

Re: Sort by month (9,10,11..) & year (2018, 2019..)

Hi @Allav,

 

I don't think so it is possible to break an order of an axis. An axis is always ascending or descending, but you expect, that there are for example 10, 11, 12, 1, 2, 3, ...

What you can do, is to create a new column with a format like yyyy-MM (e.g. 2019-02) and use it as your axis. Then the values will always go up.

2 REPLIES 2
Nolock Established Member
Established Member

Re: Sort by month (9,10,11..) & year (2018, 2019..)

Hi @Allav,

 

I don't think so it is possible to break an order of an axis. An axis is always ascending or descending, but you expect, that there are for example 10, 11, 12, 1, 2, 3, ...

What you can do, is to create a new column with a format like yyyy-MM (e.g. 2019-02) and use it as your axis. Then the values will always go up.

Allav Frequent Visitor
Frequent Visitor

Re: Sort by month (9,10,11..) & year (2018, 2019..)

Thanks, after trying few different options I think that your sugestion is the only way to go about it. I could not find a way to do sorting by 2 fields.