topic Re: Distinct Counts in SAS Visual Analytics

Distinct Counts

DavidPhillips2 — Fri, 10 May 2019 18:11:24 GMT

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

Re: Distinct Counts

Sam_SAS — Fri, 10 May 2019 18:13:58 GMT

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

Re: Distinct Counts

DavidPhillips2 — Fri, 10 May 2019 18:21:17 GMT

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

Re: Distinct Counts

PetriRoine — Fri, 10 May 2019 19:57:36 GMT

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#n0r2de9vkep76bn1tjb53x9l43g3.htm

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

Best regards,

Petri Roine

Re: Distinct Counts

DavidPhillips2 — Fri, 10 May 2019 20:01:15 GMT

Thanks