Filtering on a count(Problem)

building reports desktopintelligence
1

Hello, I am having a problem with a report. This is the circumstance. In the report I have two fields, one is device and the other is Job names. I then do a count on the number of job names. Some have 1,2, 3,4,5,6,7,8 etc. I want to filter on the count. But there does not seem to be a way.

Example of report

Device Job number
tns4154s 2345187
Count 1

Device Job number
ert7676 2367900
7633478
7698679
8799995
5456739
Count 5

I did the count using the calculator.
The only devices I want in my report are the ones with a count of more than 4.

I cannot figure out how to filter this report to only see the devices with more than 4 job numbers.

Thanks,
Shirley Knight Andersen Consulting on TI engagement shkk@ti.com 972-927-6340

Listserv Archives (BOB member since 2002-06-25)

2

Shirley,

I recommend making a new variable which basically says the following:

=if (count(job number) IN Device) > 4 then “Y” else “N”

Then put a filter on the new variable (obviously, selecting on the “Y” values) This will keep your filter dynamically updated.

Jason Beard
AGD Consulting

===================================================================== Hello, I am having a problem with a report. This is the circumstance. In the report I have two fields, one is device and the other is Job names. I then do a count on the number of job names. Some have 1,2, 3,4,5,6,7,8 etc. I want to filter on the count. But there does not seem to be a way.

Example of report

Device Job number
tns4154s 2345187
Count 1

Device Job number
ert7676 2367900
7633478
7698679
8799995
5456739
Count 5

I did the count using the calculator.
The only devices I want in my report are the ones with a count of more than 4.

Listserv Archives (BOB member since 2002-06-25)