KPI Filtering

[cm]

Smart people,

Question about KPI filtering...

KPI data is the following:

Count({<[Incident Type]={"Personnel"} [Incident Number])

Unfiltered, the KPI is returning the correct number.

When I filter on a field different from, and exclusive of, [Incident Type]... the KPI above is still returning a number >0. It should be returning zero.

Essentially I want the KPI to show ONLY count({<[Incident Type]={"Personnel"} [Incident Number]), and to return a zero when I'm filtering on anything but [Incident Type].

Any advice?

[sunny_talwar]

---

@cm wrote:

Essentially I want the KPI to show ONLY count({<[Incident Type]={"Personnel"} [Incident Number]), and to return a zero when I'm filtering on anything but [Incident Type].

---

Do you mean that if you select something other than Personnel within Incident Type, you want to see 0? Try this

Count({<[Incident Type] *= {"Personnel"}>} [Incident Number])

[Channa]

=if([Incident Type]='Personal',count(Incidentnumber),0)