Using variable in an Expression vs. by itself

[Anonymous]

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)

[sunny_talwar]

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.