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.
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
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
