Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Count({$<[Planner Group]={'SVC'},[True 90 Day] = {'Yes'}>} [SO TECO Date])/Count({$<[Planner Group]={'SVC'},[Customer Owned] = {'Yes'}>} [SO TECO Date])
I use the above expression to get the % True 90 day. In the chart, it’s giving the expected result with having the line graph on the chart. However, when I click on the
True 90 Day = ‘Yes’ filter, the chart loses the line graph. The True 90 day has values of (‘Yes’,’No’,’Blank’). I can see the line graph when selecting the ‘Blank’ but loses it when I select either ‘Yes’ or ‘No’.
Can you please help me with the correct expression so that I’ll not lose the line graph even when selecting from the filter. Thank you in advance.
Maybe clear the selection in this field in your second aggregation:
=Count({$<[Planner Group]={'SVC'},[True 90 Day] = {'Yes'}>} [SO TECO Date])
/
Count({$<[Planner Group]={'SVC'},[Customer Owned] = {'Yes'}, [True 90 Day]=>} [SO TECO Date])
It worked! Thank you.