Distinct Counts

[DavidPhillips2]

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

[Sam_SAS · Accepted solution]

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]

...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]

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]

Thanks