2 Replies Latest reply on Jan 22, 2015 9:20 AM by James Keuning

    Count distinct days for aggregated data - I know this answer is out there, I just can't find it.

    James Keuning

      Pretty simple, I want to know how many days my users are in the system. (Or in this sample data, on how many days they eat fruit.)

       

      I am trying to determine, for each role, what is the average number of days. So, for manager I should use 6 days. For Sales, 5 days.

       

       

      But when I countd at that level, I get a result that makes sense, but not the one that I want.