Avg function not working as expected

[#1]

Hi everyone,

I have some problems with my expression with the Avg funtion in it.

My formula is: Avg(Aggr([1],[2],[3],[4],[5],[6],[7],[8],[9],[10]))

And it shows an output value but it's not correctly.

I have also some statistic objects which calculates the average of a column and I think that's working fine but in my KPI it's not.

When using a calculator and calculate the average of the statistic object I have another output then my KPI is showing.

Please see the attachment to clear some things up.

The 3 KPI's have all 3 groups of columns(answers) you can see on the right side.

Please ask me if you need further info or another screenshot, thanks a lot!

[tresesco]

Is it a chart or text box you are writing this expression in? If chart, which chart? what are the dimensions?

[#3]

Hi

AGgr function is similar to SQL group by, so you have to a dimension that you r grouping by

thanks

padma

[#4]

Thanks for the quick reply, I'm using this in the gauge chart and have no dimensions defined.

[#5]

Thanks for your reply.

So I have to add a group in the dimension tab?

Like this:

[#6]

Hi

is it possible to have sample qvw

regards

padma

[#7]

Sure, see attachment.

[Anonymous · Accepted solution]

Try Below,

RangeAvg(Avg([1]),Avg([2]),Avg([3]),Avg([4]),Avg([5]),Avg([6]),Avg([7]),Avg([8]),Avg([9]),Avg([10]))

Or

RangeAvg(Sum([1]),Sum([2]),Sum([3]),Sum([4]),Sum([5]),Sum([6]),Sum([7]),Sum([8]),Sum([9]),Sum([10]))

[#9]

It works exactly like I wanted.

Thanks a lot!