Skip to main content
Solved

Per user averages

  • November 17, 2022
  • 2 replies
  • 1093 views
I

Dear community,

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)) 

 

Thank you!

Best answer by Matrak

Hello !

You need to add the amount of users to your like_ratio. 

Thus, to calculate the average like_ratio per user, I would first try computing a formula using:

  • TOTALS_like / (TOTALS_like + TOTALS_dislike): this formula allows you to get your “like_ratio”
  • AVG(): allows you to get the average event triggered by user

The formula would be “AVG(like_ratio formula)”. However, it does not seems to work as we cannot use AVG on another formula.

 

Then, I would try to add an extra event to determine the amount of unique users (using the most common event occuring such as a view page if you are using a website). You can now compute the following formula: like_ratio / UNIQUES(common event).

This should look like that:

(TOTALS_like / (TOTALS_like + TOTALS_dislike))/UNIQUES(view page)


In my opinion, this formula should get the average you are looking for. 
Hope it helps! 

View original
    Did this topic help you find an answer to your question?

    2 replies

    Matrak
    Peer Moderator
    Forum|alt.badge.img+6
    • Matrak
    • Peer Moderator
    • 20 replies
    • Answer
    • November 23, 2022

    Hello !

    You need to add the amount of users to your like_ratio. 

    Thus, to calculate the average like_ratio per user, I would first try computing a formula using:

    • TOTALS_like / (TOTALS_like + TOTALS_dislike): this formula allows you to get your “like_ratio”
    • AVG(): allows you to get the average event triggered by user

    The formula would be “AVG(like_ratio formula)”. However, it does not seems to work as we cannot use AVG on another formula.

     

    Then, I would try to add an extra event to determine the amount of unique users (using the most common event occuring such as a view page if you are using a website). You can now compute the following formula: like_ratio / UNIQUES(common event).

    This should look like that:

    (TOTALS_like / (TOTALS_like + TOTALS_dislike))/UNIQUES(view page)


    In my opinion, this formula should get the average you are looking for. 
    Hope it helps! 

    Jacenda Davis
    Team Member
    Forum|alt.badge.img+5

    @Ingmar Oemig Thanks for your post! Matrak, provided a suggestion for how to calculate your average ‘like_ratio’  per user:

     

    This should look like that:

    (TOTALS_like / (TOTALS_like + TOTALS_dislike))/UNIQUES(view page)

     

    At this time you cannot apply the AVG() formula on top of another formula calculation, therefore the above suggestion is the closest option available for calculating the average like_ratio per user. If this does not suffice, I am also happy to file a feature request on your behalf.

     

    I hope this helps! 

    -Jacenda 

    Matrak
    1 person likes this
    • Matrak
      Matrak

    Reply


    Helpful Members this Week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings