Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
variable1 Definition:
Fractile({<NumberField=>} if(TimeField < vVariable2, TimeField), vVariable3)
If it's used by itself as an expression, as one of the columns of a Straight Chart like:
=$(vVariable1)
It displays values correctly. Each row has a distinct value.
But, when this variable is used inside an expression in the same chart; the expression doesn't work, for example, the expression:
=Avg({<NumberField=, TimeField={'<$(=vVariable1)'}>} TimeField)
When you use this this as set analysis the variable is evaluated once per chart. What that means is that if you use this variable in a text box object, whatever value you get will be used across the chart. Set analysis doesn't get evaluated on each dimension. The work around this is to use Aggr() function.