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?
Go to Solution.
AVG( Aggr( Sum(IncidentCount), yourdimension, Month) )
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