Count Distinct ID where ID Occurs more than once

[Anonymous]

Hi All,

I am trying to create a chart from my data set where I am getting a count of distinct id's where the id occurs more than once.

Below is a look at a pivot chart i created using the data. Any idea?

[sunny_talwar]

May be this

Count({<ID = {"=Count(ID) > 1"}>}ID)

[Anonymous]

Hi stalwar1,

I have tried that formula but it doesnt seem to work for some reason.

Finbar

[sunny_talwar]

It may be confidential, but are you using set analysis between Count and ID which you have colored in Red? Are you using the same set analysis in the Search string?

[Anonymous]

I am doing a simple count(id) in the table above. So it is telling me how many times the unique policy id occurs in the table.

[sunny_talwar]

I was asking about this

Is the hidden part in Red a set analysis? or what?

[Anonymous]

No it is a simple count... i just hid part of the column name.

[sunny_talwar]

oh okay... can you post a screenshot with this new expression

Count({<ID = {"=Count(ID) > 1"}>}ID)

[Anonymous]

The second column is where your expression has been added

[sunny_talwar]

Oh so it is working... all you need to do is.... remove the first expression and under Add-ons -> Data handling uncheck 'Include Zero Values'