Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created measure that in the denominator ignore Year Dim:
count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count({<Year=,TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)
When I defined KPI with this measure I received the number 103% as a result.
When I defined as a graph\table with this measure and Year field as a dim I received the number 106% as a result and the number 103% as total function Auto (You can see printscreen in the attachment)
Do you know why its occur?
Thanks!
You used Year in set analysis causing that disregards the year field selection. For disregarding dimension in a chart for totaling, try like:
count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count(Total <Year> {<TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)
You used Year in set analysis causing that disregards the year field selection. For disregarding dimension in a chart for totaling, try like:
count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count(Total <Year> {<TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)