2 Replies Latest reply on Feb 5, 2019 12:32 PM by Pauline Tisseyre

    Average

    Pauline Tisseyre

      Hi there!

       

      I would like to add in my viz the average number of registrations per location.

       

      For example, Ohio Dominican University in 2017 has Sum of Registration = 42

       

       

      When you open the tooltip of that cell, you see that 42 is the sum of 2 sessions:

      - July 11,2017: 23

      - July 17,2017: 19

       

      I would like to create the average per location and per year. So for example Average Reg in Ohio Dominican University in 2017 would be: (23+19)/2=21

       

      Any idea how I can create this calculated field?

       

      Thanks!
      Pauline