Stack Overflow
Stack Overflow

Questions tagged [ranking]

Ranking is the sorted order of an element in a list of elements. Usually a high ranking means the element is good in terms of certain metric.

is used in:

  • sorting algorithms
  • information retrieval to represent the relevance of documents with respective to the search queries.
  • recommendation to rank top-k items.
1634 questions
0
votes
1 answer

Ranking a list of numbers that may have repeating digits

I am looking for a way to rank the very first change in a sequence of numbers within a list that may contain duplicates... example... rec# number 1 328 2 32C 3 32C 4 328 5 328 What I am looking for is to find the first 328 as…
user3512989
  • 1
0
votes
1 answer

SQL Ranking Statement for Access- Duplicates in Results

I have a simple Access table [Parts] that stores the data Part# CYTD_SALES CUST_NUM I need to rank the parts in terms of CYTD Sales (Current Year To Day Sales) for each CUST_NUM (Customer Number) separately I am using the following…
Aquarelle
  • 23
  • 1
  • 5
0
votes
1 answer

Ranking by category in R

I have a data frame and I want to return a ranking for each Category based on PCC. > head(newdf) ItemId Category PCC 1 5063660193 Go to Gifts 2 2 24154563660193 Go to Gifts 1 2.1 24154563660193 All Gifts 1 3 …
Gianluca
  • 6,307
  • 19
  • 44
  • 65
0
votes
1 answer

SQL Server: add ranking to nested selects

I am using the following stored procedure which works fine so far. Can someone tell me how I have to change this in order to get a ranking for each of the nested Selects ? What I am looking for is a new rank that gets added to each of them so that…
user2571510
  • 11,167
  • 39
  • 92
  • 138
0
votes
2 answers

Leaderboard, with position, dealing with same points and skipping to next

I have some code where I calculate the users points and position on the leaderboard then display them in descending order based on their points/score. At the moment I have done the numbering so that it looks like this 1 2 2 3 3 3 4 However I…
Dannymh
  • 149
  • 1
  • 11
0
votes
1 answer

Resolving ties in MySQL rankings

I have a MySQL table that looks something like this: GOALS ------------------------ PLAYER | GOALS ------------------------ 001 | 30 002 | 25 003 | 25 004 | 20 I want to have a rank-based scoring…
g1derekl
  • 13
  • 2
0
votes
1 answer

SumProduct Not Working with Date Values

So I am trying to come up with a ranking system that will start at 1, and increment for every different client we have, and reseting each month. Heres what I have: =SUMPRODUCT(--([Client]=[@[Client]]), --([Receive Date]> [@[Receive Date]]) )+1 When…
J-Pwn
  • 3
  • 3
0
votes
1 answer

What's the most customizable rank system?

I need a rank system ( like stars etc.) for my website. Do you know eny scripts that are highly customizable? I would like to use it with a CMS, not as stand alone aplication. Any sugestions will be very helpful
Simon
  • 1
0
votes
1 answer

redis zrank: get "last 7 days" rank

I want to show three rankings: overall, last 30 days and last 7 days. I decided to use redis although I've never worked with it before. The overall rankings seem pretty easy: Every time a user registers I create a new member to my collection and…
Alexander Scholz
  • 2,100
  • 1
  • 20
  • 35
0
votes
2 answers

Rank column based on a specific column with same row values for MySQL

I wanted to create something that will rank the distance on which is nearest to the user via a query. Now the only problem is that I'm not sure how to implement it for MySQL. I'm thinking of something like Rank partition by implementation in Oracle.…
KaHeL
  • 4,301
  • 16
  • 54
  • 78
0
votes
2 answers

What methods are available to automatically deal with spammers with PHP/MySQL

I am currently creating a news ranking application wherein I have users connected to one another, and can post news items to a database. Users can vote on said news items within a rating of 10 - 1. 10 giving the item the highest possible vote and in…
Pixulated
  • 33
  • 1
  • 7
0
votes
1 answer

Need Rating and ranking Mysql tutorial

I would like a simple example tutorial on how to rank user votes Example: from a table of list of 20 people I would like for users to be able to vote on several categories of those people Vote for Best Eyes Vote for Best Face Vote for Best…
user3330441
  • 1
  • 1
0
votes
3 answers

Rank system - Determine ranking of multiply objects assigned with two variables

I'm sorry if this is a little strange question. I'm trying to determine every object (assigned with two variables [rounds, x]). Rounds means how many time the object have moved around a track (like a race car?) x is how far the object is form start…
user1824857
0
votes
2 answers

Reddit Ranking Algorithm - Rising

I am using this algorithm based of Reddit and want to change it so it shows rising posts rather than hot. Which number do I change so that the time between posting and now have a greater influence on the returned score? I have tried changing a few…
Matt Ellwood
  • 105
  • 1
  • 13
0
votes
1 answer

Are there reputation systems designed to provide an absolute score based on relative ranking?

(Meta: not sure whether this question is suitable for StackOverflow, it has an AI/statistics slant. Feel free to recommend which StackExchange site is more suitable.) A lot of reputation systems, like eBay, Slashdot, AirBnB and StackOverflow base a…
Grundlefleck
  • 124,925
  • 25
  • 94
  • 111
1 2 3
…
99 100