Count Distinct, Set Analysis

[pkelly]

Hi...

I have created a Dashboard to look at some Credit Analysis...

I have two lines of KPI's on the Dashboard (each with a text box to show each KPI) showing stats for the previous month (cad_HistoricalMonthNumber = 1)...

On the first line I have the Total issues then a site breakdown of same ...

Total Issues        Glasgow   Oxford...

20                        15             5

On the second line, I have a breakdown of the reason codes...

Sales     Yard    Distribution....

10           5        3

I have a site filter which, when selected, I want to affect the second line only i.e. I do not want the first line of KPI's to be affected by the filters...

I have tried the following with no success for my Total Issues KPI but with no success...

NUM(COUNT({1}DISTINCT {$<cad_HistoricalMonthNumber = {1}> } %IssueKeyHeader), '#,##0;(##,##0)') 

Am sure i am doing something basic wrong and would be grateful for any assistance...

Thanks

Paul

[swuehl · Accepted solution]

You are including to set identifiers here, I think that is the issue. Try like

NUM(COUNT( DISTINCT {1<cad_HistoricalMonthNumber = {1}> } %IssueKeyHeader), '#,##0;(##,##0)') 

[pkelly]

Thanks swuehl - spot on...