Apologies if I’m asking an already asked question here.
Is there a way to view the average of a ‘formula’ event over the users. Specifically, I have a parameter ‘like_ratio’ that is generated as like / (like + dislike).
I am interested in the average like_ratio per user - not weighted by likes and dislikes, but just a clean average.
If I make a segmentation chart of totals_like / (totals_like + totals_dislike) I get a chart weighted by activity (the most active user will weigh more in the result).
Is there a way to create the average of the per user like_ratio?
I have tried the avg(like) / (avg(like) + avg(dislike)) but I get a wildly different number from what I get when exporting user data and taking the avg(like / (like + dislike))
Best answer by MatrakView original