Hello! I have a string column for Month. When i am sorting this by a-z it is giving me alphabetical orer. How can I do chronological order for a string column with values “April”, “May”, “June”, etc…
Hi @Skodati8, to sort the month in chronological order, you’ll need to create a month sort column in the dataset or in the analysis as shown below. After that column is created, go to the Field Wells of the x-axis → select Sort options → Select the month sort column you created to sort by → select aggregation as sum → click Apply.
Here’s an example of how to create the month sort column.
ifelse({Month} = ‘January’,1,
{Month} = ‘February’,2,
{Month} = ‘March’,3,
{Month} = ‘April’,4,
{Month} = ‘May’,5,
{Month} = ‘June’,6,
{Month} = ‘July’,7,
{Month} = ‘August’,8,
{Month} = ‘September’,9,
{Month} = ‘October’,10,
{Month} = ‘November’,11,
{Month} = ‘December’,12,0)
Screenshot of Sort Options
1 Like
Hi thank you for your answer,
Is it possible to do the same in a filter that I have created from a parameter to be use in the dashboard? I would like the user to see the months in the right order, instead of alphabetical, without adding a number in front of the months like: ‘01-Jan’, etc.