Average Issue

[khammBostik]

I'm relatively new to Qlik and stuck. I have a table that is created as a visualization. The table is giving me an auto generated average.

 

When I try to create a KPI visualization for one of the fields in the table (using the same master item) I don't get the correct average that my table shows. 

I'm taking the master item and in the function filed adding "Avg(field)" I've also tried changing it to "Sum(field)/Count(field)" either way it doesn't work. I do have "-" fields does that matter? What am I doing wrong?

[Somasundaram]

Hi,

If you are using table with average as expression it will consider dimensions as well.
If you are using KPI Object it will not consider and will give entire average. Please check with table dimensions.