Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
xarapre7
Creator II
Creator II

% True 90 Day

=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.

2 Replies
swuehl
MVP
MVP

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])

xarapre7
Creator II
Creator II
Author

It worked!  Thank you.