SetAnalysis with Fields range

[Anonymous]

Hi

I need to calculate Result field which is AVG of AVG_VAL but its take only range between MinRange and MaxRange.

I try to wrote this:

Avg({<Attenuator = {'>=MinRange<=MaxRange' }>}AVG_Val)

But didn't get any result.

Any suggestions?

Thanks

Ravit.

[sunny_talwar]

Set analysis is evaluated once per chart, you may have to use Aggr() with if or just if statement here? Can you share if MinRange and MaxRange are expression or a hard-coded value?

[Anonymous]

Hi

MinRange and MaxRange are database fields. that can be dynamic and change each row.

[sunny_talwar · Accepted solution]

Oh okay, I got you... are they going to be used as a dimension in this chart? If they will be, then may be this

Avg(If(Attenuator >= MinRange and Attenuator <= MaxRange, AVG_Val))

[Anonymous]

Thanks a lot!