Trend line with % value as Data points

[pranaview]

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!

[Brett_Bleess]

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

[pranaview · Accepted solution]

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