Average

[Anonymous]

Hi guys,

Please help me with idea how to calculate TOTAL average  "Overall experience" only for text tags in "Main Issue" field.

I have a list box, where a customer can select any tags of  "Main Issue".

The data is below

I used an expression

Avg(TOTAL {<[Main issue]=,[Main issue]=P()>}[Overall experience])

it works right until selection any tag from "Main issue"

Cheers,

[Gysbert_Wassenaar]

I don't really understand what result you expect. Can you post some examples? Maybe this works: Avg({1<[Main issue]={'*'}>}[Overall experience])

[Anonymous · Accepted solution]

Thanks, It works. I just modified for a chart

=Avg({<[Main issue]={'*'}>} TOTAL [Overall experience])