1 Reply Latest reply on Jul 29, 2018 4:20 AM by Ankit Bansal

    Finding average when there are many obs per id, think I need LOD

    none given

      I have many observations per id.  I'm trying to find the average, defined as: total_sales / total_users. The number of obs for each id is obviously affecting my average and making it incorrect (for my use).

       

      Attached is an example:

       

      My desired output is:

      North: 200   ((100+200+300) / 3)

      South: 125    ((50+100+150+200) / 4 )

       

      Thanks for your help!