BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

In Visual Analytics.  I have columns ID, and Course.  How can I show the distinct number of times that each ID i related to a course?

 

The output should look like

 

Math PersonA 3 

Math PersonB 2

Math PersonC 5

 

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee

Hi David,

 

Wouldn't a list table with the columns ID, Course, and Frequency work? You would want to disable "detail data" in the list table options.

 

Sam

View solution in original post

4 REPLIES 4
Sam_SAS
SAS Employee

Hi David,

 

Wouldn't a list table with the columns ID, Course, and Frequency work? You would want to disable "detail data" in the list table options.

 

Sam

DavidPhillips2
Rhodochrosite | Level 12

...Yes.  I think I ran into an odd scenario where I"m trying to view rows by the primary Id of the table and the Id list was too long for the display.  Its likely a security setting.  When I added a filter it worked.

PetriRoine
Pyrite | Level 9

Hello @DavidPhillips2 ,

 

You actually bumped into high-cardinality thresholds for report objects. For example tables are limited to 40000 rows. You can find more info from here:

http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n0r2de9vkep76bn1tjb53...

 

BTW: In the current VA 8.3 you can override these thresholds in the Report Designer options.

 

Best regards,

Petri Roine

DavidPhillips2
Rhodochrosite | Level 12

Thanks

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 615 views
  • 0 likes
  • 3 in conversation