2 Replies Latest reply: Aug 8, 2017 10:53 AM by Liron Baram RSS

    Measure not working as desired

    Siddharth Sheshadri

      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?

       

      Snippet.PNG