Aggr Count

[cbaqir]

The goal is to show a count of Providers with Duplicate entries (same NPI, name, specialty) at a facility.

In the example below, in the detailed chart, I use =if(count( NPI)>=2,count(NPI)) and get 262 as the numeric count of rows (as opposed to the sum of the rows). This means there are 262 providers at this facility that are duplicated.

I want a bar chart to show the total number of duplicate providers at each facility but this number is not the same. I believe I need to use an AGGR statement but I can't figure out how. The bar chat's only dimension would be facility but I still want to show the same logic.

This is not giving me what I need: =sum(aggr(count( NPI)>=2,FACILITY))

[sunny_talwar · Accepted solution]

May be this?

=Sum(Aggr(If(Count(NPI) >= 2, 1), FACILITY, NPI, FULL_NAME))

[cbaqir]

Long time no chat, Sunny! Thanks

[cbaqir]

One more question... I need a count if NPI is null by Facility.

[sunny_talwar]

May be

NullCount(NPI)