Forum Discussion
Sorting a date column by another column not working
Found my own janky solution.
It was because of date data type.
In the query I set the Period/Date column to text type then I was able to sort by my Base Act Order column.
I took it a step further and added a conditional column in the query to find columns that begin with 1/1, 2/1, 3/1, etc and added the month name then switched it back to date type after the conditional column step.
My matrix and graphs are now sorting correctly.
If anyone has a better solution I'd be happy to hear.
Found my own janky solution.
It was because of date data type.
In the query I set the Period/Date column to text type then I was able to sort by my Base Act Order column.
I took it a step further and added a conditional column in the query to find columns that begin with 1/1, 2/1, 3/1, etc and added the month name then switched it back to date type after the conditional column step.
My matrix and graphs are now sorting correctly.
If anyone has a better solution I'd be happy to hear.