28 Replies Latest reply: Aug 4, 2016 7:30 AM by Bharat Kishore RSS

    Need to calculate average

    Bharat Kishore

      Hi All,


      I have a straight table chart and in the presentation tab i have given max number as 10 values.


      I have campaign and email send date as dimension and my expression is


      sum([Unique Clickthroughs])/sum([Total Sends]).


      Now by doing this i have got some values.


      Now i needed an expression to calculate the avg of those 10 values.


      Attached excel for reference and how i am calculating  the values.