Hello,
I want to use Set Analysis, or a similar function, to make a selection on a gauge chart. The problem is that I want to apply it to a part of my expression but this part doesn't have a aggregation.. My expression:
=(
count( distinct{$ <[Calls.Service ordersoort] - {'OVERIG'} , [Norm.Group] = {'VX'}>} Calls.Callnr))
/(
sum({$ <[Norm.Group]={'VX'}>} TMS.CNT)/ count(distinct TMS.IBDATE))
/(((
Norm.Norm)/365)*count(Day))
It shows a percentage of the number of calls on a specific type of product considering its installed base and versus its treshold. The last part of the expression looks at the treshold and calculates it to the number of selected days. This Norm.Norm (the treshold) should only look at the Norm.Group 'VX', just like the rest. But their is no relevant aggregation.. Is there a similar function to say 'just look at Norm.Norm when the Norm.Group='VX'?
Thanks, Sander