Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I make the KPI chart with two KPI's - the first one should be an absolute number and the second KPI should show this number in percentage. I have used the expression:
count([Opportunity Line Number])/count(total [Opportunity Line Number]) for the percentage formula
but it shows always 100%, even I do selections in the other charts.
Thanks
total outside chart make no sense, maybe you want this?
count([Opportunity Line Number])/count({1}[Opportunity Line Number])
can you provide the sample data
It's correct that it is always 100 % because if you count a field (with selection or not) without set analysis for example, count total anyway.
Then those two expression are always the same.
total outside chart make no sense, maybe you want this?
count([Opportunity Line Number])/count({1}[Opportunity Line Number])
thanks! What is what I needed 🙂