Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
Count(DISTINCT {<AGENTS, COD = {"=Sum({<[DATA.autoCalendar.Year]={'2021'}, AGENTS>}VALUE) > 0"}>} COD)
Try this
Count(DISTINCT {<AGENTS, COD = {"=Sum({<[DATA.autoCalendar.Year]={'2021'}, AGENTS>}VALUE) > 0"}>} COD)
Question: Why do you need to use
AGENTS,
instead of agents =,
?
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)