Sort month filter not alphabetically but by date order

[sebHan]

Hey! I have a problem with one of my filters. 

My data is build up such that I have a field called "last Date in Month", where I have extracted the month with the load editor:

Then I've added the following filter in my app:" =Concat(distinct Month, ' | ')", which displays as the following screenshot:

I would like this filter to be sorted by "Jan | Feb | Mar | ....." instead.

Can anybody help me on how to do this?

[AshutoshBhumkar · Accepted solution]

Hi,

You can add sort weight parameter in Concat () function. Try below

Concat(distinct Month, ' | ',Date)

Thanks,

Ashutosh

[sebHan]

Hey,

It returns "Error in expression" when trying this solution 😕

[AshutoshBhumkar]

Any screenshots ? or sample data ?

[AshutoshBhumkar]

The result should look like this.

E.g 

Since you have Monthend dates in your data, I have used sort weight as Monthend(InvoiceDate) to get the distinct dates.

[sebHan]

Yeah so this actually worked 

=Concat(Distinct Month, ' | ', Date(Month))

was the solution. Thanks!