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
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
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
...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.
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:
BTW: In the current VA 8.3 you can override these thresholds in the Report Designer options.
Best regards,
Petri Roine
Thanks
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.