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.

       

      Thanks

      Bharat