# Average Rating

**URL:** <https://community.glideapps.com/t/average-rating/28773>\
**Category:** Ask for Help\
**Created:** [July 6, 2021, 9:59am UTC](https://community.glideapps.com/t/average-rating/28773 "2021-07-06T09:59:15Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sharath\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sharath_s/32/28000_2.png) [@Sharath\_S](https://community.glideapps.com/u/Sharath_S)\
**Post date:** [July 6, 2021, 9:59am UTC](https://community.glideapps.com/t/average-rating/28773/1 "2021-07-06T09:59:15Z")

</div>

When can we expect average rating (all users) from Glide?

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [July 6, 2021, 10:15am UTC](https://community.glideapps.com/t/average-rating/28773/2 "2021-07-06T10:15:25Z")

</div>

You can do that yourself in the data editor with a math column.

---

<div class="post-metadata">

**Author:** ![Sharath\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sharath_s/32/28000_2.png) [@Sharath\_S](https://community.glideapps.com/u/Sharath_S)\
**Post date:** [July 6, 2021, 12:46pm UTC](https://community.glideapps.com/t/average-rating/28773/3 "2021-07-06T12:46:41Z")

</div>

jeez, never thought about it… thanks🙂

---

<div class="post-metadata">

**Author:** ![Sharath\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sharath_s/32/28000_2.png) [@Sharath\_S](https://community.glideapps.com/u/Sharath_S)\
**Post date:** [July 28, 2021, 2:40pm UTC](https://community.glideapps.com/t/average-rating/28773/4 "2021-07-28T14:40:37Z")

</div>

rollup right?

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [July 28, 2021, 6:42pm UTC](https://community.glideapps.com/t/average-rating/28773/5 "2021-07-28T18:42:25Z")

</div>

Yeah make a column rollup amount of points + coumn amount of users and a column where you divide points through users

---

<div class="post-metadata">

**Author:** ![Sharath\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sharath_s/32/28000_2.png) [@Sharath\_S](https://community.glideapps.com/u/Sharath_S)\
**Post date:** [July 30, 2021, 2:15pm UTC](https://community.glideapps.com/t/average-rating/28773/6 "2021-07-30T14:15:00Z")

</div>

Small issue, say, it’s for rating for a particular restaurant and there are 20+ restaurants in the then? how do I it, should I have to join them both and then relate? I’m confused 😬

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [July 30, 2021, 2:30pm UTC](https://community.glideapps.com/t/average-rating/28773/7 "2021-07-30T14:30:56Z")

</div>

I made an app with users + movies + reviews that’s comparible.  
Reviews are related to movies (restaurants in your case).  
With a lookup function I collect the points in the related reviews per movie.  
Then I make a sum of those points that I divide through the amount of reviews.

---

<div class="post-metadata">

**Author:** ![Sharath\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sharath_s/32/28000_2.png) [@Sharath\_S](https://community.glideapps.com/u/Sharath_S)\
**Post date:** [July 30, 2021, 3:23pm UTC](https://community.glideapps.com/t/average-rating/28773/8 "2021-07-30T15:23:29Z")

</div>

you pull the reviews to a column in your movies DE, then do the calculations right?

if it’s not too much to ask can you share a screen shot of the editor 😬

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [July 30, 2021, 3:41pm UTC](https://community.glideapps.com/t/average-rating/28773/9 "2021-07-30T15:41:23Z")

</div>

![1.Overall](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7572e14f5a0c3aeb290c11a3b9e95e739cbbca4.png)  
 ![2.LookupRatings](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c99d5888bbab50c18477d245d5ce1fd0cdba400.png)  
 ![3.TotalPoints](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46a672a65c9f61d98c0ce30eec1b4b1f41652a25.png)  
 ![4.TotalVotes](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94693aa8a004a389fa393b23ba19c2d39d58caee.png)  
 ![5.Average](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27c9264d47f178bad5d79dc4a78b4dea20ea094b.png)

---

<div class="post-metadata">

**Author:** ![Sharath\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sharath_s/32/28000_2.png) [@Sharath\_S](https://community.glideapps.com/u/Sharath_S)\
**Post date:** [July 31, 2021, 10:05am UTC](https://community.glideapps.com/t/average-rating/28773/10 "2021-07-31T10:05:57Z")

</div>

thank you so much, I will try this out and let you know the desired outcome 😌, missed this reply 😬😬

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/average-rating/28773/11 "2024-01-17T16:51:05Z")

</div>