Forum Discussion
Solved
Sorting by Month Number
Hello, I have a month and year column. I have created a conditional column which gives me the month number based on the month name. When I try to sort the data by the conditional column(Number), ...
Getting the same results. It's weird because if you look at the screenshots, after sorting only Oct Nov Dec are unsorted rest everything is sorted.
In the query editor, select your query, select your month (ie., number) column, right click, change type, click whole number.
You can do the same using Data Type as "whole number".
Basically, when you added conditional column, it shows Data Type as Any. You need to fix it as Whole number.
After this, Verify: Data Tab in the main app: Make sure for the month: january, feb ... column, sort by column is still the number column.
Save. Now the order should be good and recreate the chart (if it is not fixed).
Awesome, glad to head that issue is fixed :)
Cheers,