Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to complete a set Analysis that incorporates 3 different dimensions as a percentage of the total documents created.
KPI: (Count({$<Perception={"Complaint"},Department={"Cust Service"},[BU-Business Unit]={"C&C"}>}Document))/(Count(Document))
However, I have the same information in a line graph and the numbers don't correlate. I have Order Created Date, and Business Unit as my Dimensions. And (Count({$<Perception={"Complaint"},Department={"Cust Service"}>}Document))/(Count(Document)) as the measure.
However If I pick a month the two numbers do not match. My KPI with the above formula gives me 0.02% where the line graph gives me 0.05%. If I click on the data point in the graph then my KPI will update correctly, but it then is shows its filtering by Business Unit. Its like the KPI formula isn't limiting by Business Unit.
How can I fix this?
I also tried this version that I saw online:
(Count({$<Perception={"Complaint"}>*$<Department={"Cust Service"}>*$<[Business Unit]={"C&C"}>}Document))/(Count(Document))
I still have the same issue with multiple dimensions written that way.