Sort ascending month name

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?
image

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:
image

1 Like

You could also prepend the order to the month name:

1 January
2 February
3 March

1 Like