Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Requirement: So I have a field which has different teams on it and we have a KPI value in %. Now if that value for May-20 is 95% then i need to show the reason for the rest 5% which is basically the Team field. So just for the sake of example if i have 4 teams in the field then i want to show 4 different trend lines in the chart with Month being on the X-axis and 5% distributed among the 4 teams on the Y-axis.
I used an expression like below
Count({< Flag = {'0}>} ID)/Count({<Flag = {'0,'1'}>} Total <Month> ID)
Where Dimensions are Team and Month fields. This works unless i select a particular month in which case the 5% changes to relative %.
Hope i have made the requirement clear enough, any suggestion would be appreciated.
Thanks!
Hi Brett,
I got it done by using multiple expressions instead of that single dimension so i think we can close this thread.
Thanks!
Pranav
All but impossible for folks to try to help with the QVW in these cases, as we need to be able to see data model etc. in order to check fields you are using etc...
Regards,
Brett
Hi Brett,
I got it done by using multiple expressions instead of that single dimension so i think we can close this thread.
Thanks!
Pranav