8 Replies Latest reply: Apr 19, 2018 11:42 AM by Sunny Talwar RSS

    Set analysis chart measure ignoring axis dimension

    Davin Reid-Montanaro

      What I am trying to achieve is have a chart which shows the total number of events per day divided by the total number of people in a group.


      Some of the people in the group do not ever have an event, so when I add the event_date as an axis these are excluded from the base count.


      If you look at the second tab of the attached QVF file you can see what I'm trying to achieve, I would normally have thought that the following expression:


      COUNT(TOTAL <status> DISTINCT {<event_date=>} customer_id)


      But this only gives me the number of customers who have ever had an event, and does not include the count of people who have not had one event ever.