I want to analyse how much MRR we have per user per month. For this I have a property on group level (customer) that states the MRR.
I also have the number of users by looking at “Any Active Event” Uniques.
But I cannot divide the “sum of all MRR” by the “number of users” because I would need to propsum the MRR by grouping by the customer, but only on 1 event per customer per month. If I do this on any event that occurs more often than once MRR is summed up for each of these events instead of once per customer.