Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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