Avg vg Avg(aggr()) at chart

[cmano]

Hello guys.

I have the below chart.

I use this expression : Avg([Mean value]) results on the chart.

No they want to convert this chart to boxplot. I use the box plot wizard and i take this chart

I create a table to verify the values : 

As you can see the mean values are not the same ( for middle measurements at least). 

The expression at boxplot is : Avg(Aggr([Mean value],[Order],[Mean value]))

I create bar charts with these 2 expressions and the results are not the same.

The questions are :

Why i take different results with different expressions of average?

How i can resolve this issue? I mean boxplot avg to be the same as bar chart?

thank you.

[hic]

First, you need to ask average of WHAT? Of the transactions (the individual records)? Or of the average per Order? Those are different. See https://community.qlik.com/t5/Design/Average-Which-average/ba-p/1466654

Also, I think you want a different Aggr() call. I suggest not having [Mean value] as dimension. Also, make sure that you use an inner aggregation function. Hence:

Avg(Aggr(Avg([Mean value]),[Order]))

See https://community.qlik.com/t5/Design/Pitfalls-of-the-Aggr-function/ba-p/1463275