Update 10/04/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 641.119
Total Txs: 334.028
From Users: 21.941
To Users: 33.614
minDate: 2018-01-24 22:12:21
maxDate: 2020-04-10 02:47:01
Aggregate awarded sMerit for the last complete week (30/03/2020 .. 05/04/2020) is 6.036 which is up 17,09% from the previous week.
In addition, there are 2 more Legendary and 2 more Hero members this week:
Baofeng -> Legendary from Sr. Member during Merit System kick-off.
mu_enrico -> Legendary from Old Era Newbie during Merit System kick-off. -> The first !!!
BITCOIN4X -> Hero from New Era Newbie during Merit System kick-off.
YOSHIE -> Hero from New Era Newbie during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
Topic: Bitcointalk Merit Dashboard - page 23. (Read 39911 times)
Update 03/04/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 629.736
Total Txs: 327.376
From Users: 21.882
To Users: 33.422
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-27 02:27:20
Aggregate awarded sMerit for the last complete week (23/03/2020 .. 29/03/2020) is 5.155 which is down 11,33% from the previous week.
In addition, there are 1 more Legendary and 1 more Hero this week:
xtraelv -> Legendary from Full Member during Merit System kick-off.
Cnut237 -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 629.736
Total Txs: 327.376
From Users: 21.882
To Users: 33.422
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-27 02:27:20
Aggregate awarded sMerit for the last complete week (23/03/2020 .. 29/03/2020) is 5.155 which is down 11,33% from the previous week.
In addition, there are 1 more Legendary and 1 more Hero this week:
xtraelv -> Legendary from Full Member during Merit System kick-off.
Cnut237 -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
I’ve moved a couple of things around and added some filters in order to retrieve an interesting view on some information, which I recently drafted for my local board, and thought it would be interesting to include in the Merit Dashboard. Specifically:
- I’ve deleted the "Top Merited Thread Ranking" from the Rankings Tab.
- But I’ve added it to the "Most Merited Post" Tab, which now displays most merited posts and threads (renamed tab to "Most Merited Post/Threads").
Now the nice part is that we can now filter the "Most Merited Post/Threads" by:
- To User name/id, in order to view the posts and threads where you have received most merit on.
- From User name/id, in order to view the posts and threads that you have merited most.
- Section/Subsection, in order to delimit the scope to a specific set of boards (if no users are delimited, it spans to the whole set of selected boards).
- If no filters are applied, it spans to all merited threads and post forum wide.
- Date slider allows the scope to be restricted to a specific period of time (i.e. 2020 onwards).
Output Columns:
Classification: Ranking (number of obtained merits descending).
Merit: Number of obtained merits.
Post_title/page_title: Merited post or thread.
Section: First level board classification.
Subsection: Second level board classification.
nFromUsers: Number of distinct users that have merited the given post/thread.
nToUsers: Number of distinct merited users within the post/thread.
nPosts: Number of merited posts within the thread (in accordance to applied filters).
https://public.tableau.com/views/BitcointalkMeritDashboard/MostMeritedPostsThreads?:display_count=y&:origin=viz_share_link
Output examples:
a) Most Merited (by me) threads and post:
The largest amount of sMerits I have awarded to a single post (until this week, where I merited some of the top recurrent threads) is 7.
The thread I have merited most is the 10th Anniversary art contest, where I awarded 334 sMerits to 168 different users and on 224 distinct posts.
b) Posts and Threads on which I sent most merit on the Spanish Local board:
The post section shows that I’ve awarded a maximum of 4 sMerits thrice on my local board.
The thread section shows that I’ve awarded 31 merits to a Coronavirus topic, to 10 different users within the thread, and totalling 28 different merited (by me) posts.
The second thread I’ve awarded most merits there is on a topic about the low activity on the Spanish Local board, having awarded 21 sMerits to 17 different users for 19 different posts.
Likewise, filtering by ToUserName (rather than FromUserName) will display those threads and posts where one has been most merited on.
- I’ve deleted the "Top Merited Thread Ranking" from the Rankings Tab.
- But I’ve added it to the "Most Merited Post" Tab, which now displays most merited posts and threads (renamed tab to "Most Merited Post/Threads").
Now the nice part is that we can now filter the "Most Merited Post/Threads" by:
- To User name/id, in order to view the posts and threads where you have received most merit on.
- From User name/id, in order to view the posts and threads that you have merited most.
- Section/Subsection, in order to delimit the scope to a specific set of boards (if no users are delimited, it spans to the whole set of selected boards).
- If no filters are applied, it spans to all merited threads and post forum wide.
- Date slider allows the scope to be restricted to a specific period of time (i.e. 2020 onwards).
Output Columns:
Classification: Ranking (number of obtained merits descending).
Merit: Number of obtained merits.
Post_title/page_title: Merited post or thread.
Section: First level board classification.
Subsection: Second level board classification.
nFromUsers: Number of distinct users that have merited the given post/thread.
nToUsers: Number of distinct merited users within the post/thread.
nPosts: Number of merited posts within the thread (in accordance to applied filters).
https://public.tableau.com/views/BitcointalkMeritDashboard/MostMeritedPostsThreads?:display_count=y&:origin=viz_share_link
Output examples:
a) Most Merited (by me) threads and post:
The largest amount of sMerits I have awarded to a single post (until this week, where I merited some of the top recurrent threads) is 7.
The thread I have merited most is the 10th Anniversary art contest, where I awarded 334 sMerits to 168 different users and on 224 distinct posts.
b) Posts and Threads on which I sent most merit on the Spanish Local board:
The post section shows that I’ve awarded a maximum of 4 sMerits thrice on my local board.
The thread section shows that I’ve awarded 31 merits to a Coronavirus topic, to 10 different users within the thread, and totalling 28 different merited (by me) posts.
The second thread I’ve awarded most merits there is on a topic about the low activity on the Spanish Local board, having awarded 21 sMerits to 17 different users for 19 different posts.
Likewise, filtering by ToUserName (rather than FromUserName) will display those threads and posts where one has been most merited on.
Update 27/03/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 629.736
Total Txs: 327.376
From Users: 21.882
To Users: 33.422
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-27 02:27:20
Aggregate awarded sMerit for the last complete week (16/03/2020 .. 22/03/2020) is 5.814 which is up 22,09% from the previous week.
In addition, there are 1 more Legendary and 5 more Heroes this week:
Goran_ -> Legendary from Full Member during Merit System kick-off.
20kevin20 -> Hero from Sr. Member during Merit System kick-off.
BitcoinTurk -> Hero from Full Member during Merit System kick-off.
lossnet -> Hero from Full Member during Merit System kick-off.
rdbase -> Hero from Full Member during Merit System kick-off.
TravelMug -> Hero from Sr. Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 629.736
Total Txs: 327.376
From Users: 21.882
To Users: 33.422
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-27 02:27:20
Aggregate awarded sMerit for the last complete week (16/03/2020 .. 22/03/2020) is 5.814 which is up 22,09% from the previous week.
In addition, there are 1 more Legendary and 5 more Heroes this week:
Goran_ -> Legendary from Full Member during Merit System kick-off.
20kevin20 -> Hero from Sr. Member during Merit System kick-off.
BitcoinTurk -> Hero from Full Member during Merit System kick-off.
lossnet -> Hero from Full Member during Merit System kick-off.
rdbase -> Hero from Full Member during Merit System kick-off.
TravelMug -> Hero from Sr. Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
<…>
I’ll look into it further along if I can. The silly little think that currently calls for a pre-calculation onf the information (as opposed to deriving the race information from the granular data already present on the Merit Dashboard) is the sorting by rank feature. I gave it a longish go last week-end, but did not find a way other than by pre-calculating for each day.Pre-calculating does open the option to finding some fun facts, like which was the top rank position and when the first occurrence took place of that position, in contrast with the current position:
Code:
user_id name nBestPosition DateOfPositon nCurrentPos
2143453 1miau 13 2019-09-09 23:59:59.000 14
1878246 abhiseshakana 13 2019-07-30 23:59:59.000 23
290195 achow101 10 2019-08-29 23:59:59.000 12
465017 actmyname 10 2018-01-27 23:59:59.000 96
1762404 Alex_Sr 33 2019-03-10 23:59:59.000 89
1580039 asche 40 2018-03-15 23:59:59.000 80
1015954 aundroid 57 2018-01-28 23:59:59.000 75
1169179 BitCryptex 38 2019-03-12 23:59:59.000 50
1554927 bitmover 24 2018-07-06 23:59:59.000 44
1018510 Blacknavy 5 2018-01-24 23:59:59.000 100
579628 bob123 19 2019-09-12 23:59:59.000 34
569455 BobLawblaw 8 2018-01-25 23:59:59.000 52
64205 Carlton Banks 13 2018-02-03 23:59:59.000 56
879277 Coding Enthusiast 34 2018-01-30 23:59:59.000 60
1339716 coinlocket$ 22 2019-04-26 23:59:59.000 58
1980983 Coolcryptovator 46 2019-02-21 23:59:59.000 62
2005913 Corrosive 68 2018-04-16 23:59:59.000 85
1052091 CryptopreneurBrainboss 63 2019-12-27 23:59:59.000 71
507936 DarkStar_ 17 2018-01-26 23:59:59.000 48
1582324 DdmrDdmr 2 2019-01-19 23:59:59.000 5
2003859 DireWolfM14 32 2020-02-29 23:59:59.000 33
580327 eddie13 51 2018-03-02 23:59:59.000 86
1067333 El duderino_ 5 2019-04-15 23:59:59.000 6
359716 ETFbitcoin 33 2019-03-27 23:59:59.000 53
1852120 fillippone 7 2020-01-29 23:59:59.000 7
155345 gentlemand 24 2018-02-06 23:59:59.000 37
11425 gmaxwell 10 2019-12-31 23:59:59.000 10
1039323 Goran_ 30 2018-02-02 23:59:59.000 74
181806 HairyMaclairy 11 2018-01-24 23:59:59.000 24
867786 HCP 15 2019-08-03 23:59:59.000 19
881377 Hhampuz 8 2018-01-24 23:59:59.000 22
397737 hilariousetc 5 2018-09-18 23:59:59.000 15
1059082 hugeblack 15 2018-01-24 23:59:59.000 68
1827294 Husna QA 39 2018-05-04 23:59:59.000 47
1291828 iasenko 16 2018-01-24 23:59:59.000 20
2204241 ICOEthics 37 2019-06-11 23:59:59.000 99
1094195 igor72 86 2019-01-13 23:59:59.000 93
41175 infofront 17 2018-02-19 23:59:59.000 88
252510 JayJuanGee 13 2018-01-25 23:59:59.000 32
698159 Jet Cash 7 2018-08-05 23:59:59.000 38
49008 jojo69 6 2018-01-24 23:59:59.000 55
1275282 joniboini 9 2018-05-16 23:59:59.000 45
487377 Kalemder 30 2018-01-25 23:59:59.000 84
1000199 krogothmanhattan 10 2018-05-18 23:59:59.000 30
805820 Lafu 55 2018-01-26 23:59:59.000 94
479624 Last of the V8s 4 2018-07-08 23:59:59.000 8
101872 Lauda 2 2018-01-24 23:59:59.000 29
379487 LFC_Bitcoin 17 2020-03-13 23:59:59.000 17
1982152 lovesmayfamilis 60 2019-12-18 23:59:59.000 64
459836 LoyceV 2 2019-01-21 23:59:59.000 2
1894120 madnessteat 81 2020-03-07 23:59:59.000 83
787736 marlboroza 9 2018-01-31 23:59:59.000 36
1283017 masulum 76 2018-03-22 23:59:59.000 82
2033515 mikeywith 13 2019-12-28 23:59:59.000 13
176777 mindrust 34 2018-01-29 23:59:59.000 92
346731 minerjones 6 2018-01-25 23:59:59.000 70
886521 mk4 44 2018-01-30 23:59:59.000 91
405464 mocacinno 10 2018-01-24 23:59:59.000 66
1424178 mole0815 21 2018-02-03 23:59:59.000 67
1825672 morvillz7z 51 2019-09-20 23:59:59.000 59
1574226 mu_enrico 36 2019-05-07 23:59:59.000 54
1237156 nc50lc 38 2018-01-25 23:59:59.000 72
976210 nullius 3 2018-02-17 23:59:59.000 35
317618 nutildah 15 2019-10-25 23:59:59.000 16
1188543 o_e_l_e_o 4 2019-10-09 23:59:59.000 4
1304130 pandukelana2712 8 2018-01-29 23:59:59.000 79
1071136 PHI1618 19 2018-02-18 23:59:59.000 81
64507 philipma1957 9 2018-01-24 23:59:59.000 61
188198 Piggy 13 2018-11-24 23:59:59.000 63
379147 pooya87 31 2020-03-12 23:59:59.000 31
358020 Quickseller 28 2018-01-25 23:59:59.000 97
24140 qwk 18 2019-05-08 23:59:59.000 27
2627711 Ratimov 68 2020-03-11 23:59:59.000 69
1051955 roycilik 31 2019-04-20 23:59:59.000 41
38894 SaltySpitoon 37 2019-05-24 23:59:59.000 77
3 satoshi 2 2018-01-25 23:59:59.000 11
1112531 Steamtyme 21 2019-11-04 23:59:59.000 25
164749 stompix 34 2018-01-25 23:59:59.000 90
234771 suchmoon 3 2019-05-10 23:59:59.000 3
1855828 taikuri13 49 2019-11-14 23:59:59.000 57
487418 The Pharmacist 5 2019-01-09 23:59:59.000 9
679341 TheFuzzStone 63 2018-02-03 23:59:59.000 98
35 theymos 1 2018-01-24 23:59:59.000 1
1180530 theyoungmillionaire 11 2018-08-05 23:59:59.000 76
98986 TMAN 3 2018-01-26 23:59:59.000 43
239406 Toxic2040 13 2018-01-24 23:59:59.000 78
1292764 tranthidung 44 2020-01-21 23:59:59.000 49
557798 TryNinja 16 2018-01-26 23:59:59.000 39
1311641 tvplus006 52 2018-05-24 23:59:59.000 65
1138727 VB1001 21 2020-02-22 23:59:59.000 21
1177936 Veleor 30 2019-11-22 23:59:59.000 40
30747 Vod 4 2018-01-24 23:59:59.000 28
84521 Welsh 26 2018-01-28 23:59:59.000 95
1433865 witcher_sense 51 2020-02-27 23:59:59.000 51
131333 wwzsocki 45 2018-01-28 23:59:59.000 87
1068464 Xal0lex 57 2018-01-26 23:59:59.000 73
120694 xhomerx10 14 2019-06-03 23:59:59.000 18
897509 xtraelv 11 2018-11-08 23:59:59.000 26
355846 yahoo62278 6 2018-01-26 23:59:59.000 46
140827 yogg 27 2018-01-27 23:59:59.000 42
2143453 1miau 13 2019-09-09 23:59:59.000 14
1878246 abhiseshakana 13 2019-07-30 23:59:59.000 23
290195 achow101 10 2019-08-29 23:59:59.000 12
465017 actmyname 10 2018-01-27 23:59:59.000 96
1762404 Alex_Sr 33 2019-03-10 23:59:59.000 89
1580039 asche 40 2018-03-15 23:59:59.000 80
1015954 aundroid 57 2018-01-28 23:59:59.000 75
1169179 BitCryptex 38 2019-03-12 23:59:59.000 50
1554927 bitmover 24 2018-07-06 23:59:59.000 44
1018510 Blacknavy 5 2018-01-24 23:59:59.000 100
579628 bob123 19 2019-09-12 23:59:59.000 34
569455 BobLawblaw 8 2018-01-25 23:59:59.000 52
64205 Carlton Banks 13 2018-02-03 23:59:59.000 56
879277 Coding Enthusiast 34 2018-01-30 23:59:59.000 60
1339716 coinlocket$ 22 2019-04-26 23:59:59.000 58
1980983 Coolcryptovator 46 2019-02-21 23:59:59.000 62
2005913 Corrosive 68 2018-04-16 23:59:59.000 85
1052091 CryptopreneurBrainboss 63 2019-12-27 23:59:59.000 71
507936 DarkStar_ 17 2018-01-26 23:59:59.000 48
1582324 DdmrDdmr 2 2019-01-19 23:59:59.000 5
2003859 DireWolfM14 32 2020-02-29 23:59:59.000 33
580327 eddie13 51 2018-03-02 23:59:59.000 86
1067333 El duderino_ 5 2019-04-15 23:59:59.000 6
359716 ETFbitcoin 33 2019-03-27 23:59:59.000 53
1852120 fillippone 7 2020-01-29 23:59:59.000 7
155345 gentlemand 24 2018-02-06 23:59:59.000 37
11425 gmaxwell 10 2019-12-31 23:59:59.000 10
1039323 Goran_ 30 2018-02-02 23:59:59.000 74
181806 HairyMaclairy 11 2018-01-24 23:59:59.000 24
867786 HCP 15 2019-08-03 23:59:59.000 19
881377 Hhampuz 8 2018-01-24 23:59:59.000 22
397737 hilariousetc 5 2018-09-18 23:59:59.000 15
1059082 hugeblack 15 2018-01-24 23:59:59.000 68
1827294 Husna QA 39 2018-05-04 23:59:59.000 47
1291828 iasenko 16 2018-01-24 23:59:59.000 20
2204241 ICOEthics 37 2019-06-11 23:59:59.000 99
1094195 igor72 86 2019-01-13 23:59:59.000 93
41175 infofront 17 2018-02-19 23:59:59.000 88
252510 JayJuanGee 13 2018-01-25 23:59:59.000 32
698159 Jet Cash 7 2018-08-05 23:59:59.000 38
49008 jojo69 6 2018-01-24 23:59:59.000 55
1275282 joniboini 9 2018-05-16 23:59:59.000 45
487377 Kalemder 30 2018-01-25 23:59:59.000 84
1000199 krogothmanhattan 10 2018-05-18 23:59:59.000 30
805820 Lafu 55 2018-01-26 23:59:59.000 94
479624 Last of the V8s 4 2018-07-08 23:59:59.000 8
101872 Lauda 2 2018-01-24 23:59:59.000 29
379487 LFC_Bitcoin 17 2020-03-13 23:59:59.000 17
1982152 lovesmayfamilis 60 2019-12-18 23:59:59.000 64
459836 LoyceV 2 2019-01-21 23:59:59.000 2
1894120 madnessteat 81 2020-03-07 23:59:59.000 83
787736 marlboroza 9 2018-01-31 23:59:59.000 36
1283017 masulum 76 2018-03-22 23:59:59.000 82
2033515 mikeywith 13 2019-12-28 23:59:59.000 13
176777 mindrust 34 2018-01-29 23:59:59.000 92
346731 minerjones 6 2018-01-25 23:59:59.000 70
886521 mk4 44 2018-01-30 23:59:59.000 91
405464 mocacinno 10 2018-01-24 23:59:59.000 66
1424178 mole0815 21 2018-02-03 23:59:59.000 67
1825672 morvillz7z 51 2019-09-20 23:59:59.000 59
1574226 mu_enrico 36 2019-05-07 23:59:59.000 54
1237156 nc50lc 38 2018-01-25 23:59:59.000 72
976210 nullius 3 2018-02-17 23:59:59.000 35
317618 nutildah 15 2019-10-25 23:59:59.000 16
1188543 o_e_l_e_o 4 2019-10-09 23:59:59.000 4
1304130 pandukelana2712 8 2018-01-29 23:59:59.000 79
1071136 PHI1618 19 2018-02-18 23:59:59.000 81
64507 philipma1957 9 2018-01-24 23:59:59.000 61
188198 Piggy 13 2018-11-24 23:59:59.000 63
379147 pooya87 31 2020-03-12 23:59:59.000 31
358020 Quickseller 28 2018-01-25 23:59:59.000 97
24140 qwk 18 2019-05-08 23:59:59.000 27
2627711 Ratimov 68 2020-03-11 23:59:59.000 69
1051955 roycilik 31 2019-04-20 23:59:59.000 41
38894 SaltySpitoon 37 2019-05-24 23:59:59.000 77
3 satoshi 2 2018-01-25 23:59:59.000 11
1112531 Steamtyme 21 2019-11-04 23:59:59.000 25
164749 stompix 34 2018-01-25 23:59:59.000 90
234771 suchmoon 3 2019-05-10 23:59:59.000 3
1855828 taikuri13 49 2019-11-14 23:59:59.000 57
487418 The Pharmacist 5 2019-01-09 23:59:59.000 9
679341 TheFuzzStone 63 2018-02-03 23:59:59.000 98
35 theymos 1 2018-01-24 23:59:59.000 1
1180530 theyoungmillionaire 11 2018-08-05 23:59:59.000 76
98986 TMAN 3 2018-01-26 23:59:59.000 43
239406 Toxic2040 13 2018-01-24 23:59:59.000 78
1292764 tranthidung 44 2020-01-21 23:59:59.000 49
557798 TryNinja 16 2018-01-26 23:59:59.000 39
1311641 tvplus006 52 2018-05-24 23:59:59.000 65
1138727 VB1001 21 2020-02-22 23:59:59.000 21
1177936 Veleor 30 2019-11-22 23:59:59.000 40
30747 Vod 4 2018-01-24 23:59:59.000 28
84521 Welsh 26 2018-01-28 23:59:59.000 95
1433865 witcher_sense 51 2020-02-27 23:59:59.000 51
131333 wwzsocki 45 2018-01-28 23:59:59.000 87
1068464 Xal0lex 57 2018-01-26 23:59:59.000 73
120694 xhomerx10 14 2019-06-03 23:59:59.000 18
897509 xtraelv 11 2018-11-08 23:59:59.000 26
355846 yahoo62278 6 2018-01-26 23:59:59.000 46
140827 yogg 27 2018-01-27 23:59:59.000 42
Impressive effort!
You got the dashboard even better than before!
I do hope you'll be able to update the merit race at least a few time a year! (or find a way to automate it).
This is the situation the day I got my first merit:
A lot of things have changed since then!
You got the dashboard even better than before!
I do hope you'll be able to update the merit race at least a few time a year! (or find a way to automate it).
This is the situation the day I got my first merit:
A lot of things have changed since then!
Update 20/03/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 624.451
Total Txs: 324.167
From Users: 21.858
To Users: 33.317
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-20 02:50:12
Aggregate awarded sMerit for the last complete week (09/03/2020 .. 15/03/2020) is 4.762 which is up 0,95% from the previous week.
There are no new Legendries Heroes this week.
Just for fun, I added a tab at the end called "Received Merit Race" where we can observe the merit race for any user with more than 10 earned merits. The positions do not visually order on screen though in this version.
I did additionally develop a Top 100 day-to-day Merit Race though, which does reorder positions: Merit Race Top 100
Data: https://docs.google.com/spreadsheets/d/1v8CT6AvjckH6SFYiRhEB8xIItw7lg65Q2O_S1Bg2uBw/edit?usp=sharing
I will not be updating this latter one though, other than sporadically (It requires an additional pre-calculated Datasource which I prefer not to have to update each week). The one on the Regular Merit Dashboard updates each week though (but does not reorder positions on screen).
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 624.451
Total Txs: 324.167
From Users: 21.858
To Users: 33.317
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-20 02:50:12
Aggregate awarded sMerit for the last complete week (09/03/2020 .. 15/03/2020) is 4.762 which is up 0,95% from the previous week.
There are no new Legendries Heroes this week.
Just for fun, I added a tab at the end called "Received Merit Race" where we can observe the merit race for any user with more than 10 earned merits. The positions do not visually order on screen though in this version.
I did additionally develop a Top 100 day-to-day Merit Race though, which does reorder positions: Merit Race Top 100
Data: https://docs.google.com/spreadsheets/d/1v8CT6AvjckH6SFYiRhEB8xIItw7lg65Q2O_S1Bg2uBw/edit?usp=sharing
I will not be updating this latter one though, other than sporadically (It requires an additional pre-calculated Datasource which I prefer not to have to update each week). The one on the Regular Merit Dashboard updates each week though (but does not reorder positions on screen).
<…>
It seems fine to me, at least this morning. I’ve tried it on two different devices with no issues (other than the fact that the TX tab is slow to load – 30 seconds – but in its usual line). The Dashboard link in the OP really opens in the Global Summary tab, which is pretty immediate to load. Perhaps you saved a link to the Dashboard on the TX tab, but it not the default one really.
Sometimes I’ve encountered Tableau errors popping up. I normally close the browser to give it a fresh start in these cases, although a page refresh normally resolves the issue (which is usually, if not always, related to the Tableau infrastructure).
Lastly, at the bottom of the page there is a link to the Current Status (under the information link). It should drive us to this page: https://trust.tableau.com. The page shows a status on Tableau Public (which is what we are using here), and there have been no entries in the issue log since last Saturday. The log is not always that fast to report a situation though (i.e. I notices issues on Saturday, and the status did not reflect it until over an hour later).
Maybe all those quarantined kids in Italy, playing Fortnite and streaming all day long, are slowing down the interent.
Thank you for checking.
<…>
It seems fine to me, at least this morning. I’ve tried it on two different devices with no issues (other than the fact that the TX tab is slow to load – 30 seconds – but in its usual line). The Dashboard link in the OP really opens in the Global Summary tab, which is pretty immediate to load. Perhaps you saved a link to the Dashboard on the TX tab, but it not the default one really.
Sometimes I’ve encountered Tableau errors popping up. I normally close the browser to give it a fresh start in these cases, although a page refresh normally resolves the issue (which is usually, if not always, related to the Tableau infrastructure).
Lastly, at the bottom of the page there is a link to the Current Status (under the information link). It should drive us to this page: https://trust.tableau.com. The page shows a status on Tableau Public (which is what we are using here), and there have been no entries in the issue log since last Saturday. The log is not always that fast to report a situation though (i.e. I notices issues on Saturday, and the status did not reflect it until over an hour later).
Is it just me or the Dashboard has become extremely slow?
Does the fact it opens by default on the on the TXs page is slowing it a little bit?
Also a lot of errors popping out after awhile I am simply looking at the page.
Am I the only one?
Does the fact it opens by default on the on the TXs page is slowing it a little bit?
Also a lot of errors popping out after awhile I am simply looking at the page.
Am I the only one?
Update 13/03/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 618.986
Total Txs: 320.970
From Users: 21.826
To Users: 33.239
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-13 02:50:20
Aggregate awarded sMerit for the last complete week (02/03/2020 .. 08/03/2020) is 4.717 which is down 19,13% from the previous week.
In addition, there is 1 more Legendary and 1 more Hero this week:
BrewMaster -> Legendary from Hero Member during Merit System kick-off.
Lambie Slayer -> Hero from New Era Newbie during Merit System kick-off.
Added Tabs on Merit/Post ratios -> See OP on this thread.
Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 618.986
Total Txs: 320.970
From Users: 21.826
To Users: 33.239
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-13 02:50:20
Aggregate awarded sMerit for the last complete week (02/03/2020 .. 08/03/2020) is 4.717 which is down 19,13% from the previous week.
In addition, there is 1 more Legendary and 1 more Hero this week:
BrewMaster -> Legendary from Hero Member during Merit System kick-off.
Lambie Slayer -> Hero from New Era Newbie during Merit System kick-off.
Added Tabs on Merit/Post ratios -> See OP on this thread.
Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.
<…>
As @hosseinimr93 indicates, some profiles had an initial amount of Merits (and sMerits) when the system kicked-off. Specifically, they had an airdropped amount of Merits equivalent to their rank at the time. Therefore, a Member would have and airdrop of 10 Merits, a Full Member a 100, a Sr. Member 250, and so on. On the Dashboard, I’m usually displaying earned merits (meaning non-airdropped merits). The Rankings Tab you mentioned displays earned Merits.Only on the tabs where I display Activity and Posts alongside Merits do I display various Merit counters:
Merits (Total Merits), Merits Received (earned Merits) and Initial Merits (airdropped Merits). These are displayed for example in the Personal Summary Tab (on the top left cuadrant), the User Summary Tab.
Can you please explain how the Merited User Ranking list works? It's showing the top 1 merited user is theymos with 6591 merits but his profile on the forum is showing a different number which is 7591. Thank you!
The merit dashboard shows earned merit. But the forum shows total merit (earned merit + airdropped merit). Theymos has earned 6591 merit and has 1000 airdropped merit. When merit system was implemented, all users of the forum except newbies received airdropped merits, so they are not deranked. All legendary members including theymos received 1000 airdropped merit.
Update 06/03/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 614.072
Total Txs: 317.783
From Users: 21.807
To Users: 33.158
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-06 02:51:54
Aggregate awarded sMerit for the last complete week (24/02/2020 .. 01/03/2020) is 5.833 which is down 14,82% from the previous week.
In addition, there is 1 more Legendary and 1 more Hero this week:
Saint-loup -> Legendary from Sr. Member during Merit System kick-off.
amishmanish -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.
Can you please explain how the Merited User Ranking list works? It's showing the top 1 merited user is theymos with 6591 merits but his profile on the forum is showing a different number which is 7591. Thank you! The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 614.072
Total Txs: 317.783
From Users: 21.807
To Users: 33.158
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-06 02:51:54
Aggregate awarded sMerit for the last complete week (24/02/2020 .. 01/03/2020) is 5.833 which is down 14,82% from the previous week.
In addition, there is 1 more Legendary and 1 more Hero this week:
Saint-loup -> Legendary from Sr. Member during Merit System kick-off.
amishmanish -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.
Update 06/03/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 614.072
Total Txs: 317.783
From Users: 21.807
To Users: 33.158
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-06 02:51:54
Aggregate awarded sMerit for the last complete week (24/02/2020 .. 01/03/2020) is 5.833 which is down 14,82% from the previous week.
In addition, there is 1 more Legendary and 1 more Hero this week:
Saint-loup -> Legendary from Sr. Member during Merit System kick-off.
amishmanish -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 614.072
Total Txs: 317.783
From Users: 21.807
To Users: 33.158
minDate: 2018-01-24 22:12:21
maxDate: 2020-03-06 02:51:54
Aggregate awarded sMerit for the last complete week (24/02/2020 .. 01/03/2020) is 5.833 which is down 14,82% from the previous week.
In addition, there is 1 more Legendary and 1 more Hero this week:
Saint-loup -> Legendary from Sr. Member during Merit System kick-off.
amishmanish -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.
Update 28/02/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 609.374
Total Txs: 314.736
From Users: 21.778
To Users: 33.065
minDate: 2018-01-24 22:12:21
maxDate: 2020-02-28 02:42:36
Aggregate awarded sMerit for the last complete week (17/02/2020 .. 23/02/2020) is 6.848 which is up 17,16% from the previous week.
In addition, there are 3 more Legendries and 1 more Heroe this week:
exstasie -> Legendary from Hero Member during Merit System kick-off.
nc50lc -> Legendary from Member during Merit System kick-off.
roycilik -> Legendary from Full Member during Merit System kick-off.
Trofo -> Hero from Full Member during Merit System kick-off.
Note:
I'm still working on deriving the real rank for some Copper Members and non-native ranks (staff, etc). Not completely finished, so they may be some unresoved cases still pending to deal with properly (/wrong case).
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 609.374
Total Txs: 314.736
From Users: 21.778
To Users: 33.065
minDate: 2018-01-24 22:12:21
maxDate: 2020-02-28 02:42:36
Aggregate awarded sMerit for the last complete week (17/02/2020 .. 23/02/2020) is 6.848 which is up 17,16% from the previous week.
In addition, there are 3 more Legendries and 1 more Heroe this week:
exstasie -> Legendary from Hero Member during Merit System kick-off.
nc50lc -> Legendary from Member during Merit System kick-off.
roycilik -> Legendary from Full Member during Merit System kick-off.
Trofo -> Hero from Full Member during Merit System kick-off.
Note:
I'm still working on deriving the real rank for some Copper Members and non-native ranks (staff, etc). Not completely finished, so they may be some unresoved cases still pending to deal with properly (/wrong case).
Update 21/02/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 603.065
Total Txs: 310.913
From Users: 21.750
To Users: 32.957
minDate: 2018-01-24 22:12:21
maxDate: 2020-02-21 02:41:29
Aggregate awarded sMerit for the last complete week (10/02/2020 .. 16/02/2020) is 5.845 which is down 3,53% from the previous week.
In addition, there are 1 more Legendary and 4 more Heroes this week:
bct_ail -> Legendary from Sr. Member during Merit System kick-off.
hd49728 -> Hero from Old Era Newbie during Merit System kick-off.
logfiles -> Hero from New Era Newbie during Merit System kick-off.
Polar91 -> Hero from Sr. Member during Merit System kick-off.
vycl87 -> Hero from Member during Merit System kick-off.
Note: Still pending-> There are some issues identifying rank-up for Legendary Copper Members and staff. Not sure what I'll do here, since the rank is not on the profile, and is not strictly derivable from merits and activity (activity is a range). This causes that the Dashboard to identify an Old Era Newbie ranked-up to Legendary this week, which is not true. I'll try to resolve it next week.
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 603.065
Total Txs: 310.913
From Users: 21.750
To Users: 32.957
minDate: 2018-01-24 22:12:21
maxDate: 2020-02-21 02:41:29
Aggregate awarded sMerit for the last complete week (10/02/2020 .. 16/02/2020) is 5.845 which is down 3,53% from the previous week.
In addition, there are 1 more Legendary and 4 more Heroes this week:
bct_ail -> Legendary from Sr. Member during Merit System kick-off.
hd49728 -> Hero from Old Era Newbie during Merit System kick-off.
logfiles -> Hero from New Era Newbie during Merit System kick-off.
Polar91 -> Hero from Sr. Member during Merit System kick-off.
vycl87 -> Hero from Member during Merit System kick-off.
Note: Still pending-> There are some issues identifying rank-up for Legendary Copper Members and staff. Not sure what I'll do here, since the rank is not on the profile, and is not strictly derivable from merits and activity (activity is a range). This causes that the Dashboard to identify an Old Era Newbie ranked-up to Legendary this week, which is not true. I'll try to resolve it next week.
Update 14/02/2020:
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 595.992
Total Txs: 306.907
From Users: 21.724
To Users: 32.876
minDate: 2018-01-24 22:12:21
maxDate: 2020-02-14 02:37:50
Aggregate awarded sMerit for the last complete week (03/02/2020 .. 09/02/2020) is 6.059 which is down 9,61% from the previous week.
In addition, there are 2 more Legendries this week:
Blacknavy -> Legendary from Sr. Member during Merit System kick-off.
Royse777 -> Legendary from Hero Member during Merit System kick-off.
Note: I've just noticed that here are some issues identifying rank-up for Legendary Copper Members and staff. Not sure what I'll do here, since the rank is not on the profile, and is not strictly derivable from merits and activity (activity is a range). This causes that the Dashboard to identify an Old Era Newbie ranked-up to Legendary this week, which is not true. I'll try to resolve it next week.
NEW (with recalculated data as of today):
The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link: BitcoinTalk Merit Dashboard.
Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 595.992
Total Txs: 306.907
From Users: 21.724
To Users: 32.876
minDate: 2018-01-24 22:12:21
maxDate: 2020-02-14 02:37:50
Aggregate awarded sMerit for the last complete week (03/02/2020 .. 09/02/2020) is 6.059 which is down 9,61% from the previous week.
In addition, there are 2 more Legendries this week:
Blacknavy -> Legendary from Sr. Member during Merit System kick-off.
Royse777 -> Legendary from Hero Member during Merit System kick-off.
Note: I've just noticed that here are some issues identifying rank-up for Legendary Copper Members and staff. Not sure what I'll do here, since the rank is not on the profile, and is not strictly derivable from merits and activity (activity is a range). This causes that the Dashboard to identify an Old Era Newbie ranked-up to Legendary this week, which is not true. I'll try to resolve it next week.
NEW (with recalculated data as of today):
Added the lists to the Merit Dashboard. (Last tab, or https://public.tableau.com/shared/J8MWCR5H2?:display_count=y&:origin=viz_share_link). The data included is as of 07/02/2019. I’ve still got to see what update frequency to use for this tab (initially, I’ll try to make it weekly, alongside all other tabs but the one on the number of posts which is always monthly). The screen looks like this:
There are 3 sections on the screen:
a) Who ranked whom – Ranking:
It shows an ordered list of those who have ranked most people on the forum. In order to search within the list, either scroll around, or use the UserFromName filter on the right hand side of the screen (once filtered though, we’ll lose sight of the proper rank position, as it will be limited to a single entry).
b) Who ranked me:
It displays the list of profiles that ranked me up, the date, TX, merits and post. The post name is clickable, and the menu that pops-up lets you go to the post itself on Bitcointalk.
c) Who I ranked:
It displays the list of profiles that I’ve ranked-up, the date, TX, merits and post. The post name is clickable, and the menu that pops-up lets you go to the post itself on Bitcointalk.
You can change the user here in the UserName box (and press enter) in order to change the view to that of another user (applies to both sections "b" and "c" simultaneously).
There are 3 sections on the screen:
a) Who ranked whom – Ranking:
It shows an ordered list of those who have ranked most people on the forum. In order to search within the list, either scroll around, or use the UserFromName filter on the right hand side of the screen (once filtered though, we’ll lose sight of the proper rank position, as it will be limited to a single entry).
b) Who ranked me:
It displays the list of profiles that ranked me up, the date, TX, merits and post. The post name is clickable, and the menu that pops-up lets you go to the post itself on Bitcointalk.
c) Who I ranked:
It displays the list of profiles that I’ve ranked-up, the date, TX, merits and post. The post name is clickable, and the menu that pops-up lets you go to the post itself on Bitcointalk.
You can change the user here in the UserName box (and press enter) in order to change the view to that of another user (applies to both sections "b" and "c" simultaneously).
<…>
That does happen in a small set of cases (98 over 32.788 -> 0,3%). I do take that situation into account to derive the "probable initial rank" values (I apply a margin of tolerance for each rank), but the initial airdropped sMerit is calculated as follows:Profile Merits – sum(received sMerit from TXs) = Initial airdropped Merits.
Now what happens is that there is always a time gap between the two data origins:
- sMerit TXs are generated around 3 AM UTC (a bit before).
- Profiles are scraped at a rate on 1 per second, somewhere between Thursday night and Friday morning (until a few weeks ago, it went on until Friday evening).
What happens is that a few (fortunate) profiles are merited between 3AM and the time the profile is scraped. In these cases, the profile will have more merits that the corresponding sum(received sMerit from TXs), and therefore the initial sMerits for these cases can be off on a given week (probably not on the following week).
There are possible solutions to this, such as force values to the nearest logical value, or play around comparing to last week’s Initial airdropped Merits, but for such a small amount of cases it seems pecata minuta really.
Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing
There are a few errors in number of merits started with (Column J)
Number of airdropped merit can be only 0, 10, 100, 250, 500 and 1000. But there are some users with other numbers of airdropped merit.
| _________________ | _________________ |
| Airdropped Merit | Number of Users |
| _________________ | _________________ |
| 1 | 27 |
| 2 | 5 |
| 3 | 2 |
| 5 | 1 |
| 101 | 12 |
| 102 | 2 |
| 150 | 1 |
| 251 | 6 |
| 252 | 2 |
| 253 | 3 |
| 501 | 9 |
| 502 | 3 |
| 503 | 1 |
| 504 | 1 |
| 1001 | 11 |
| 1002 | 7 |
| 1003 | 3 |
| 1004 | 2 |
| _________________ | _________________ |
Jump to: