topic Re: SAS VA report : specific distinct count - is it possible? in SAS Visual Analytics

SAS VA report : specific distinct count - is it possible?

Filipvdr — Wed, 11 Feb 2015 11:08:51 GMT

Hi All,

I got the following problem:

Data looks like:

Article	Shop	Supplier	Value
A	1	SUP1	1
A	2	SUP1	1
A	2	SUP1	1
B	2	SUP2	1
B	2	SUP2	1
B	3	SUP2	1
B	3	SUP2	1
C	3	SUP3	1
C	3	SUP3	1
C	3	SUP3	1
C	4	SUP3	1
C	4	SUP3	1
C	4	SUP3	1

I want to report to count the values for each Supplier, but only select for the distinct (Article, Shop) combinations.

Is this possible in VA?

Filipvdr — Wed, 11 Feb 2015 12:55:02 GMT

ok, stupid question, i just have to use a distinct article...

MichelleHomes — Wed, 11 Feb 2015 13:01:03 GMT

You can create a new data item as a Distinct Count on your Article data item as described in the SAS(R) Visual Analytics 7.1: User's Guide - Working with Data Items

Let us know if this helps. If not, please provide a report/table of what you expect as your end result.

Kind Regards,

Michelle