topic Re: Sorting filter elements in Visual Analytics in SAS Visual Analytics

Sorting filter elements in Visual Analytics

fda2 — Mon, 04 Nov 2024 20:51:01 GMT

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:

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

Re: Sorting filter elements in Visual Analytics

Sam_SAS — Mon, 04 Nov 2024 20:56:48 GMT

Hello,

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

Sam

Re: Sorting filter elements in Visual Analytics

fda2 — Mon, 04 Nov 2024 21:02:27 GMT

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.

Re: Sorting filter elements in Visual Analytics

Sam_SAS — Mon, 04 Nov 2024 21:24:28 GMT

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.