BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Rian0126
Obsidian | Level 7

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.

Top 10 Highest Score Alerts.jpg

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

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: 

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



View solution in original post

4 REPLIES 4
Madelyn_SAS
SAS Super FREQ

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

Rian0126
Obsidian | Level 7

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.

 

ListTable_WithRank.jpg

DetailData_NotAvailable.jpg

DetailData_Notes.jpg

Madelyn_SAS
SAS Super FREQ

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: 

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



Rian0126
Obsidian | Level 7

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 630 views
  • 1 like
  • 2 in conversation