3 Replies Latest reply: Dec 18, 2017 4:06 PM by vamsi krishna sabbisetty RSS

    How do I create Average(mean) of a bucketed Measure in Qlik Sense ?

    vamsi krishna sabbisetty

      Suppose I have a measure having 3 buckets. 100k to 200k , 200k to 500k , 500k to 1M. How do I take a average of the measure based on buckets ? I.e, Average(Measure) where bucket = 100k to 200k ? .

       

      I would need to plot this data for a dimension. So, instead of bucketed measure, I would need mean of the bucketed measure over the dimension.