topic Re: How to get a distinct/unique value for Alert IDs in SAS Visual Analytics

How to get a distinct/unique value for Alert IDs

Rian0126 — Fri, 22 Oct 2021 10:37:16 GMT

Hi,

I am using a list table with a list of Top 10 Highest Scoring Alerts and the result was the Alert IDs have a duplicate. How can I make the Alert IDs as unique/distinct values? I am only aware of the distinct count in SAS Visual Analytics but not providing the unique values in visualization objects such as the list table to provide the top 10. By the way, I'm getting these data sources from SAS Visual Investigator's Postgres DB for the alerts table.

Thank you.

Re: How to get a distinct/unique value for Alert IDs

Madelyn_SAS — Fri, 22 Oct 2021 15:08:06 GMT

So, you are saying that the entire row is a duplicate? If so, do you have "Detail data" turned on for the list table?

Re: How to get a distinct/unique value for Alert IDs

Rian0126 — Mon, 25 Oct 2021 01:23:19 GMT

Hi @Madelyn_SAS . But the Detail Data option is not available since I am using top 10 Highest Score Alerts. I am using Ranks on this list table to create top 10. Is there a way that both ranking and distinct data (no duplicate) can be shown in list table? See screenshots below for details. Thank you.

Re: How to get a distinct/unique value for Alert IDs

Madelyn_SAS — Mon, 25 Oct 2021 17:56:37 GMT

Detail data is available even when you rank the table. You just cannot link from that table while detail data is used. When detail data is turned on, you can see duplicate values when ranking if you have rows that are identical. You could use aggregated data instead of detail, but that will aggregate your measures, which is likely not what you want.

If CurrentScore is the only measure in your table, you might be able to do this:

Delete the current rank.
Uncheck the Detail Data option for the table.
Create a new calculated item: MAX(CurrentScore).
Replace CurrentScore with the calculated item.
Create the rank on Alert for Top 10 of the calculated item.

Re: How to get a distinct/unique value for Alert IDs

Rian0126 — Tue, 26 Oct 2021 01:05:04 GMT

Hi @Madelyn_SAS . Thank you. It's working fine now.