Hi,
I'm trying to create a calculated field that gets the daily average revenue per user on a monthly basis. I'm using the formula SUM(Revenues)/Sum(DailyActiveUser)/30. I'm currently dividing by 30 but this is an approximation, since not all months have 30 days. I would like to be more precise, so is there a way to simply replace the '/30' bit with something more accurate?
6 answers
You can use ATTR around that computation, or any aggregate function like MAX/MIN,
