The Movie Database Support

 Ongoing Maintenance

Dear TMDb Community,

In the next few months, you might notice some changes on our site. My primary goal is, and always has been, to build the best media database on the internet and in order for me to stay true to that goal, we will be making these changes to enable TMDb to be more robust and reliable than before.

As you might recall from my 2019 recap, I have some pretty amazing plans for 2020 so stay tuned for some really fantastic launches this year!

If you have any questions please contact us at support@themoviedb.org.

Sincerely,

Travis

Get we see how many ratings a films score is based on? That would be kind of useful.

25 replies (on page 1 of 2)

Jump to last post

Next pageLast page

That'd be good.

(... And if we had vote-counts on forum posts, I'd vote up your suggestion!)

If it was up to me, I say personalized rating is the way to go. Let every film snob live in our own bubble, and find recommendations based on ratings from like-minded snobs. It'd require some substantial amount of work though, as even Netflix's system still pretty much never works. (Or maybe my taste is just too weird.)

Not answering your question, I know, but in certain views you can find that information. Click on a genre and you will find the number of votes for each movie listed: https://www.themoviedb.org/genre/80-crime

I have an idea in my head of how this data will come back nicely, with the current design.

@travisbell said:

I have an idea in my head of how this data will come back nicely, with the current design>

Can we hear it? smile

@A to Z said:

Get we see how many ratings a films score is based on? That would be kind of useful.

That would be a good thing, also a movie rating shouldn’t show up until it gets a certain amount of votes.

@TeddyBear said:

@A to Z said:

Get we see how many ratings a films score is based on? That would be kind of useful.

That would be a good thing, also a movie rating shouldn’t show up until it gets a certain amount of votes.

agreed with both ideas

A simple rating is often more popularity driven rather than qualitative

I don't use reddit, but you see this all the time on youtube. The dummest posts get thousand of upvotes. And the upvote/downvote ratio has more to do with the audience of that particular channel, than the content of the post itself.

So if you go to a Starwars film page, and make a thoughtful and intelligent post that happens to criticise that film, it will get downvotes, and a dumb post that says "woo yeah this is the greatest film of all time" will get upvoted.

holy dead thread resurrection batman!

Can we have this please? It really helps to differentiate out the "big name" releases. A film rated 5.6 with 10,000 votes is probably better than a film rated 10 by 1 vote but we have no way to tell the difference at present :'(

Hi @afly It's still on my list of things to get to but there are a number of higher priority items to finish first.

@travisbell said:

Hi @afly It's still on my list of things to get to but there are a number of higher priority items to finish first.

Hello, I did not know how to open a new question and therefore I am writing here, in the hope that you will listen.

when sorting by rating, they produce very unknown films that rated 1-2 people by very high ratings.

I suggest that in order to avoid this, consider the rating according to this formula

******* number of votes / rating ********

thus, more correct results would be issued

1/10 = 0.1

3/9 = 0.3

200/8 = 25

sorry for my English

@bagdaulet said:

when sorting by rating, they produce very unknown films that rated 1-2 people by very high ratings.

I suggest that in order to avoid this, consider the rating according to this formula

******* number of votes / rating ********

thus, more correct results would be issued

1/10 = 0.1

3/9 = 0.3

200/8 = 25

sorry for my English

Using your proposed formula, a movie rated by 200 people w/an average rating of 8 would get the same final score (25) as a movie rated by 100 people w/an average rating of 4. Does that really make any sense?

It might be better not to allow into the ranking algorithm any movie rated by fewer than, say, 100 people. Or else allow the user to specify a desired cutoff/filter for minimum number of ratings (e.g., 100, 200, 500 or whatever they desire).

@pt100 said:

It might be better not to allow into the ranking algorithm any movie rated by fewer than, say, 100 people. Or else allow the user to specify a desired cutoff/filter for minimum number of ratings (e.g., 100, 200, 500 or whatever they desire).

That's a good idea. Maybe Travis will do something like that eventually. I think currently he's still working on a feature that indicates the number of ratings in addition to the average rating, but maybe he'll also do what you suggest when he gets the time.

@pt100 said:

@bagdaulet said:

when sorting by rating, they produce very unknown films that rated 1-2 people by very high ratings.

I suggest that in order to avoid this, consider the rating according to this formula

******* number of votes / rating ********

thus, more correct results would be issued

1/10 = 0.1

3/9 = 0.3

200/8 = 25

sorry for my English

Using your proposed formula, a movie rated by 200 people w/an average rating of 8 would get the same final score (25) as a movie rated by 100 people w/an average rating of 4. Does that really make any sense?

It might be better not to allow into the ranking algorithm any movie rated by fewer than, say, 100 people. Or else allow the user to specify a desired cutoff/filter for minimum number of ratings (e.g., 100, 200, 500 or whatever they desire).

you're right I must admit I didn't even think about it

but searching the internet I found one formula

here I rewrote it in js

https://codepen.io/bagdaulet/pen/KJqXWZ

if it is possible to find out the largest number of votes as a result of the request, then all elements can be sorted by this formula

maybe TMDB API works in mongo db but mongo db I do not know and can not rewrite it

And this is a sql query in the same formula. select @a: = POW (max (count_votes), 1/10) from films; select * ((LOG (@ a, count_votes)) + raiting) / 2 as actual_raiting from films;

For those who don't know either javascript or SQL, can you post the link you found that, I assume, is for a straight algebraic formula? If it changes a linear scale to a logarithmic scale, I assume it does not alter the original ranking itself. If so, then maybe Travis could eventually implement it. But I think the easiest thing is to have a minimum number of votes as a floor to allowing the movie into the calculation, as IMDb does.

FYI, here's how IMDb provides ratings for the top 250 films:

The following formula is used to calculate the Top Rated 250 titles. This formula provides a true 'Bayesian estimate', which takes into account the number of votes each title has received, minimum votes required to be on the list, and the mean vote for all titles:

weighted rating (WR) = (v ÷ (v+m)) × R + (m ÷ (v+m)) × C

Where:
R = average for the movie (mean) = (rating)
v = number of votes for the movie = (votes)
m = minimum votes required to be listed in the Top Rated list (currently 25,000)
C = the mean vote across the whole report

Things can get awfully mathematically complicated. That's why I suggested a floor for number of votes before a title can be included in the ranking, and then a simple ranking of ratings (where there will likely be many ties).

Can't find a movie or TV show? Login to create it.

Global

s focus the search bar
p open profile menu
esc close an open window
? open keyboard shortcut window

On media pages

b go back (or to parent when applicable)
e go to edit page

On TV season pages

(right arrow) go to next season
(left arrow) go to previous season

On TV episode pages

(right arrow) go to next episode
(left arrow) go to previous episode

On all image pages

a open add image window

On all edit pages

t open translation selector
ctrl+ s submit form

On discussion pages

n create new discussion
w toggle watching status
p toggle public/private
c toggle close/open
a open activity
r reply to discussion
l go to last reply
ctrl+ enter submit your message
(right arrow) next page
(left arrow) previous page