9 Replies Latest reply: Mar 26, 2015 10:53 AM by Imtiaz Ullah RSS

    Average of total dimension vs selected record

    Imtiaz Ullah

      Hi guys,


      I am trying to calculate the avg of a value within a dimension so I can visualise to outputs.


      actual sum of current selection vs AVG of the entire dimension



      I am trying to calculate the percentage of emails opened and then compare it against the avg number of emails opened within a particular dimension.

      By this I mean that I have a one to many relationship - a list contains many mailings. List is a dimension within my data model.


      Therefore I want to calculate the avg no. Opens for the selected list vs the actual select mailing value.