- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-01-2024 08:00 PM | |||
10-22-2024 02:17 PM | |||
09-14-2024 12:01 AM | |||
01-06-2024 04:20 PM | |||
Anonymous
| 12-10-2020 02:46 PM |
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |