Forum User Ranking

Updated
Hi everyone,

Just couldn’t sleep last night so decided to do something in KNIME.
I’ve built a workflow (contains Selenium nodes) in which users are scored and ranked based on received likes, replies and like per reply (rate):

Score metanode:

I invented a system of scoring: All 3 parameters (likes, replies and the rate) are multiplied by a factor which is calculated by dividing 100 to the max value of the parameter in each period and the score is the sum of these 3 values. This way all the scores in all periods are comparable and all parameters have the same weight (true weight).

Here is the workflow (Updated*):
Forum User Ranking.knwf (83.1 KB)

I filtered the top 10 users for each period and here is the output (Updated January 17th at 3:30 PM UTC):

Maybe such a ranking will encourage users to be even more active. :blush:
Congrats to @Iris, @mlauber71 and @gab1one the top 3 forum users of all time! :hugs::smiley:

Best,
Armin

* I applied a few improvements to the workflow:

  • Now the workflow takes the top 50 users in the “Replied” field as well. (previously it was taking only the top 50 in the “Likes Received” field)

  • A “Missing Value” node is added to convert the missing values for rate column (when the number of replies are zero) to zero. So now if the user has a few likes but no replies, he/she still gets the score.

  • The total scores are now divided by 3. So the scores now scale from 0 to 100 and can be compared easier. When I say the scores are comparable: For example when @mlauber71 has the score of 69 in the month field and @armingrudd has the score of 61 in the quarter field, it means @mlauber71 has done better in this month than @armingrudd in this quarter.

18 Likes

Thank you for this illustrative statistic :blush:

3 Likes

What do you think about the scoring system?
Do you think it’s truly revealing the most helpful members?

1 Like

Armin, this is (again) amazing. Great use case. Looking forward to have a closer look at the workflow soon! :slight_smile:

– Philipp

2 Likes

Very cool workflow! I am happy I made the top 3, it shows how I did not have as much time for the forum lately, need to get back to that :slight_smile:.

Also thank you @armingrudd for being such an engaged community member!

5 Likes

Hi all!
Nice one @armingrudd. I just hope you feel asleep after this easily :smiley:
Don’t quite get the scoring system but according to names seems it is quite accurate :wink:
@gab1one that means your final thesis is done? :slight_smile:
Have a nice day,
Ivan

1 Like

Actually I’m very happy that such an idea came to my mind. Such a mid-night idea. If you investigate the scoring system you will find it very interesting. There is a factor which is calculated by dividing 100 to max value for each parameter (e.g. likes). Each parameter is then multiplied by this factor and the score would be sum of the values.
In shorter periods where likes and replies are lower but the like per reply (rate) may be high, this factor is high for likes and replies and low for the rate and as the period gets longer this behavior changes to become vice versa. So for all the periods we have scores that can be compared to each other and all the 3 parameters have a true equal weight.
For example, @Iris has about 2k replies in all time period and about 200 likes (which makes the rate about 0.1). As in all time period the number of replies are very high, the factor for this parameter is low (0.05)
and as the rates are low the factor for this one is high (62.5). So, more like per reply (higher rate) in all time period will give you much more score than the other parameters. The factor is actually balancing the values.

No, as I was excited building something I didn’t sleep :face_with_head_bandage:

Best,
Armin

I wonder why @Iris doesn’t like this?
She got the top 1 for all time in this ranking. Maybe she is celebrating somewhere…!!! :sweat_smile::wink:

Wow. What the heck have I done to show up in the all-time ranking? There has to be an error in your metric :joy: Really great work @armingrudd

Daniel

3 Likes

Hi @danielesser,
Good for you :blush:. Unfortunately I couldn’t make it to the top 10 (I’m 12th). :face_with_head_bandage:

You have a high like per reply rate in all time (1.4 - actually the second place in this field). Keep up the great work. :+1: :blush:

Best,
Armin

PS: The first post of this topic has been updated.

1 Like

love this, it really helps understanding the Selenium nodes plus it makes webscraping and processing MUCH easier.

Thank you very much!!!

4 Likes