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!