5 Replies Latest reply on Jun 12, 2018 10:36 AM by Zhouyi Zhang

    Calculate average field based on aggregate measures?

    Luke DeMuth

      Hi all,

       

      I'm running into some trouble trying to get a calculation to populate per day of the month based on the unique number of users and the total number of rides for the day.  Specifically trying to get the average number of riders per specific user.  I run into the error "cannot aggregate an already aggregate measure" and also can't seem to get the numbers to make sense going down the table.  Any ideas on how I can make this calculation appear in the table?

       

      Workbook attached.

      Thanks!

      luke