Discussion board where members can get started with Qlik Sense.
I wanted to plot an average monthly sum for a measure.
I used the below formula.
However, when I break this into a dimension, it does not work. Please see below images.
The first image gives me a false number however filtering into it gives me the right number. i.e. 24.58 is the correct average not 204k.
Where am I going wrong?
AVG( Aggr( Sum(IncidentCount), yourdimension, Month) )
View solution in original post
when using the aggr function
you need to use the desired dimension but also the chart dimensions
in your case
replace TierDimension with the real dimension field name