hello, I’m trying to create some kind of pivot table with month as my column.
the thing is that if I use month name it will be sorted as alphabetically (april, august etc.) and not chronologically.
how do I make the column shows month name but sort chronologically?
ibmc
2
I don’t think you can do it within Redash pivot tables, simplest solution is to make an extra field for ordering the columns. Something like this:
1 Like
k4s1m
3
You could also prepend the order to the month name:
1 January
2 February
3 March
1 Like
