count kpi with fixed kpi

[Carlaf_93]

Good morning,

i would like to create a fixed kpi (if i select an agent it will give me the total value).

I'm vounting the numers of code.

Count(distinct{<AGENTS=, COD={"=(SUM({<[DATA.autoCalendar.Year]={'2021'}>}VALUE))>0"}> } COD)

I would like to count the numers od cod that had a value >0 in 2021 and that doesn't filters for agents.

This formula doesn't work. If i select a singe agents my kpi change accordingly.

Any ideas?

[sunny_talwar · Accepted solution]

Try this

Count(DISTINCT {<AGENTS, COD = {"=Sum({<[DATA.autoCalendar.Year]={'2021'}, AGENTS>}VALUE) > 0"}>} COD)

[Carlaf_93]

Question: Why do you need to use 

AGENTS,

instead of agents =, 

?

[sunny_talwar]

Agents= or Agent does the same exact thing.... I like to use it without the equal sign to keep my expression cleaner, but this should work the same way

Count(DISTINCT {<AGENTS=, COD = {"=Sum({<[DATA.autoCalendar.Year]={'2021'}, AGENTS=>}VALUE) > 0"}>} COD)