Forum Discussion
How can I sort the text values in a filter object?
???
Hi Anonymous,
as meysun said you have to use "Sort By Column".
1) You have to create two calculated columns ("monthName" and "monthNumber") and visualize monthName as a filter.
2) After that you have to select "Sort By Column" and sort by monthNumber, and you gain the result.
Let Me Know If It Works.
#I'M Not An Expert#
Anonymous is absolutely right.
However this only works when the initial column to sort is already of date type. Mine works when the months names are hardcoded and do not come from a date field.
Unfortunately, there is a lot of improvement that has to be made in data types and converting.
SabineOussi I just saw your solution and I think that it's really great, I've never thought about that.
It can be very helpful!!