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

       

      Background.

      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.

       

      Regards

      Immy