Measure not working as desired

[Anonymous]

Hi all,

I wanted to plot an average monthly sum for a measure.

I used the below formula.

(AVG(

Aggr(Sum(IncidentCount),Month)

))

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?

[agigliotti · Accepted solution]

maybe this:

AVG( Aggr( Sum(IncidentCount), yourdimension, Month) )

[lironbaram]

hi

when using the aggr function

you need to use the desired dimension but also the chart dimensions

in your case

(AVG(

Aggr(Sum(IncidentCount),Month,TierDimension)

))

replace TierDimension with the real dimension field name