Sorting filter elements in Visual Analytics

[fda2]

Hello,

This is my first post here, I will try to be as clear as I can. I am new to SAS Environment.

I have a report date filter in my SAS VA report above a prompt container. The filter's elements are created to behave as :

- If the date is today or yesterday, then the report date column is shown as "2024/11/04 (today)" or "2024/11/03 (yesterday)".

- For other days report date filter shows the exact date (e.g. 2024/11/02).

I want to sort my filter's elements in descending order. But when I do this, filter elements are ordered like below: 

fda2_0-1730753285932.png

How can I correctly sort this filter's elements in descending order by calendar?

[Sam_SAS]

Hello,

Try right-clicking the filter control. I think that you should find Sort in the context menu.

Sam

[fda2]

When I right-click the filter, and hover over sort option, I see Asc and Desc options. But as I mention in my case, these options dont give the exact sorting option because my filter elements are a bit changed from calendar date.

[Sam_SAS · Accepted solution]

Looking at your screen capture above, I believe the values are being sorted in descending order as character values rather than as dates. I'm not sure you can customize the display with (Today) and keep date sorting, unless you switch to a date format that sorts well as character data such as YYYYMMDD.