Hello,
first of all, once again thank you very much for your work on your Merit Dashboard. It is a great tool you keep improving, we all utilise it and get if for granted. But we also have to understand you are putting lot of effort on it. So, I personally appreciate it.
I have a little suggestion/request.
In the Tab "Most Merited Post/Thread", when I look at the thread part, I see the filter selection applies to threads, but not apply on total number of merits, which is always the total number of the thread.
For example, I would like to know what are the most merited thread in the forum during the lat month: I think currently this tab cannot display this information, or there are other ways I can obtain this information?
Thank you,
f.
Topic: Bitcointalk Merit Dashboard - page 22. (Read 39617 times)
Update 05/06/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: 682.612
Total Txs: 358.835
From Users: 22.180
To Users: 34.384
minDate: 2018-01-24 22:12:21
maxDate: 2020-06-05 02:50:02
Aggregate awarded sMerit for the last complete week (25/05/2020 .. 31/05/2020) is 4.836 which is down 6,60% from the previous week.
In addition, there are 3 more Legendary members this week:
KTChampions -> Legendary from Full Member during Merit System kick-off.
sabotag3x -> Legendary from Hero Member during Merit System kick-off.
sportsbet.io -> Legendary from Hero 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: 682.612
Total Txs: 358.835
From Users: 22.180
To Users: 34.384
minDate: 2018-01-24 22:12:21
maxDate: 2020-06-05 02:50:02
Aggregate awarded sMerit for the last complete week (25/05/2020 .. 31/05/2020) is 4.836 which is down 6,60% from the previous week.
In addition, there are 3 more Legendary members this week:
KTChampions -> Legendary from Full Member during Merit System kick-off.
sabotag3x -> Legendary from Hero Member during Merit System kick-off.
sportsbet.io -> Legendary from Hero Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
Just added a quick tab to the Dashboard (called "last time merited") that allows us to see when we were last merited by someone, and/or when we last merited a given profile.
How it works:
1) Type in your username on the top right box, and press enter.
2) The top left list on will display the date of the last time you merited each profile. The default order is by Username, but you can click on the date header to sort by date.
3) The bottom left list displays the date when you last merited each profile (same sort order comments as above).
4) The Received Merits chart displays the overall received merits received by the UserName provided in step 1. Likewise with the Sent Merits chart.
5) If you click on a given name on the "Last Time Received" list, the "Received Merit" chart will show you how many merits per month the selected profile has sent you. Click the name from the list to deselect (and erase the applied filter).
6) Likewise, do the same in the "Last Time Sent" list to see how many merits per month you sent to a given profile on the list. Click again to deselect.
https://public.tableau.com/views/BitcointalkMeritDashboard/LastTimeMerited?:display_count=y&:origin=viz_share_link
Note: I wanted to have both lists and charts filter when you select a name from any of the lists at the same time. So far, it needs to be done separately on each list.
How it works:
1) Type in your username on the top right box, and press enter.
2) The top left list on will display the date of the last time you merited each profile. The default order is by Username, but you can click on the date header to sort by date.
3) The bottom left list displays the date when you last merited each profile (same sort order comments as above).
4) The Received Merits chart displays the overall received merits received by the UserName provided in step 1. Likewise with the Sent Merits chart.
5) If you click on a given name on the "Last Time Received" list, the "Received Merit" chart will show you how many merits per month the selected profile has sent you. Click the name from the list to deselect (and erase the applied filter).
6) Likewise, do the same in the "Last Time Sent" list to see how many merits per month you sent to a given profile on the list. Click again to deselect.
https://public.tableau.com/views/BitcointalkMeritDashboard/LastTimeMerited?:display_count=y&:origin=viz_share_link
Note: I wanted to have both lists and charts filter when you select a name from any of the lists at the same time. So far, it needs to be done separately on each list.
Update 29/05/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: 678.082
Total Txs: 356.121
From Users: 22.143
To Users: 34.283
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-29 02:50:29
Aggregate awarded sMerit for the last complete week (18/05/2020 .. 24/05/2020) is 5.178 which is down 12,55% from the previous week.
There are no new Legendary nor Hero members identified this week.
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: 678.082
Total Txs: 356.121
From Users: 22.143
To Users: 34.283
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-29 02:50:29
Aggregate awarded sMerit for the last complete week (18/05/2020 .. 24/05/2020) is 5.178 which is down 12,55% from the previous week.
There are no new Legendary nor Hero members identified this week.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
Update 22/05/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: 672.920
Total Txs: 352.880
From Users: 22.119
To Users: 34.175
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-22 02:50:10
Aggregate awarded sMerit for the last complete week (11/05/2020 .. 17/05/2020) is 5.921 which is up 10,08% from the previous week.
In addition, there are 5 more Legendary and 5 more Hero members this week:
asche -> Legendary from Old Era Newbie during Merit System kick-off.
duesoldi -> Legendary from Sr. Member during Merit System kick-off.
taikuri13 -> Legendary from Old Era Newbie during Merit System kick-off.
webtricks -> Legendary from Sr. Member during Merit System kick-off.
witcher_sense -> Legendary from Old Era Newbie during Merit System kick-off.
julerz12 -> Hero from Sr. Member during Merit System kick-off.
RapTarX -> Hero from New Era Newbie during Merit System kick-off.
tomahawk9 -> Hero from Sr. Member during Merit System kick-off.
trantute2 -> Hero from Old Era Newbie during Merit System kick-off.
trendcoin -> 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.
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: 672.920
Total Txs: 352.880
From Users: 22.119
To Users: 34.175
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-22 02:50:10
Aggregate awarded sMerit for the last complete week (11/05/2020 .. 17/05/2020) is 5.921 which is up 10,08% from the previous week.
In addition, there are 5 more Legendary and 5 more Hero members this week:
asche -> Legendary from Old Era Newbie during Merit System kick-off.
duesoldi -> Legendary from Sr. Member during Merit System kick-off.
taikuri13 -> Legendary from Old Era Newbie during Merit System kick-off.
webtricks -> Legendary from Sr. Member during Merit System kick-off.
witcher_sense -> Legendary from Old Era Newbie during Merit System kick-off.
julerz12 -> Hero from Sr. Member during Merit System kick-off.
RapTarX -> Hero from New Era Newbie during Merit System kick-off.
tomahawk9 -> Hero from Sr. Member during Merit System kick-off.
trantute2 -> Hero from Old Era Newbie during Merit System kick-off.
trendcoin -> 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.
Update 15/05/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: 667.231
Total Txs: 349.417
From Users: 22.085
To Users: 34.093
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-15 02:46:56
Aggregate awarded sMerit for the last complete week (04/05/2020 .. 10/05/2020) is 5.379 which is down 1,88% from the previous week.
In addition, there are 1 more Legendary and 3 more Hero members this week:
bL4nkcode -> Legendary from Hero Member during Merit System kick-off.
GrosWesh -> Hero from Old Era Newbie during Merit System kick-off.
muslol67 -> Hero from Sr. Member during Merit System kick-off.
Soonandwaite -> 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.
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: 667.231
Total Txs: 349.417
From Users: 22.085
To Users: 34.093
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-15 02:46:56
Aggregate awarded sMerit for the last complete week (04/05/2020 .. 10/05/2020) is 5.379 which is down 1,88% from the previous week.
In addition, there are 1 more Legendary and 3 more Hero members this week:
bL4nkcode -> Legendary from Hero Member during Merit System kick-off.
GrosWesh -> Hero from Old Era Newbie during Merit System kick-off.
muslol67 -> Hero from Sr. Member during Merit System kick-off.
Soonandwaite -> 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.
Update 08/05/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: 661.464
Total Txs: 345.833
From Users: 22.056
To Users: 34.002
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-08 02:50:52
Aggregate awarded sMerit for the last complete week (27/04/2020 .. 03/05/2020) is 5.482 which is up 15,56% from the previous week.
In addition, there are 1 more Legendary and 2 more Hero members this week:
iasenko -> Legendary from Member during Merit System kick-off.
AlcoHoDL -> Hero from Full Member during Merit System kick-off.
Phil_S -> 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: 661.464
Total Txs: 345.833
From Users: 22.056
To Users: 34.002
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-08 02:50:52
Aggregate awarded sMerit for the last complete week (27/04/2020 .. 03/05/2020) is 5.482 which is up 15,56% from the previous week.
In addition, there are 1 more Legendary and 2 more Hero members this week:
iasenko -> Legendary from Member during Merit System kick-off.
AlcoHoDL -> Hero from Full Member during Merit System kick-off.
Phil_S -> Hero from Full Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
Update 01/05/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: 655.978
Total Txs: 342.659
From Users: 22.029
To Users: 33.918
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-01 02:51:51
Aggregate awarded sMerit for the last complete week (20/04/2020 .. 26/04/2020) is 4.744 which is down 8,80% from the previous week.
In addition, there are 1 more Legendary and 1 more Hero members this week:
Veleor -> Legendary from Full Member during Merit System kick-off.
Maus0728 -> Hero from 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: 655.978
Total Txs: 342.659
From Users: 22.029
To Users: 33.918
minDate: 2018-01-24 22:12:21
maxDate: 2020-05-01 02:51:51
Aggregate awarded sMerit for the last complete week (20/04/2020 .. 26/04/2020) is 4.744 which is down 8,80% from the previous week.
In addition, there are 1 more Legendary and 1 more Hero members this week:
Veleor -> Legendary from Full Member during Merit System kick-off.
Maus0728 -> Hero from Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
Update 24/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: 651.106
Total Txs: 339.783
From Users: 22.003
To Users: 33.829
minDate: 2018-01-24 22:12:21
maxDate: 2020-04-24 02:46:56
Aggregate awarded sMerit for the last complete week (13/04/2020 .. 19/04/2020) is 5.202 which is down 2,35% from the previous week.
In addition, there are 2 more Legendary and 2 more Hero members this week:
aundroid -> Legendary from Full Member during Merit System kick-off.
DroomieChikito -> Legendary from Sr. Member during Merit System kick-off.
Corrosive -> Hero from Old Era Newbie during Merit System kick-off.
wh1rlw1nd -> Hero from 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: 651.106
Total Txs: 339.783
From Users: 22.003
To Users: 33.829
minDate: 2018-01-24 22:12:21
maxDate: 2020-04-24 02:46:56
Aggregate awarded sMerit for the last complete week (13/04/2020 .. 19/04/2020) is 5.202 which is down 2,35% from the previous week.
In addition, there are 2 more Legendary and 2 more Hero members this week:
aundroid -> Legendary from Full Member during Merit System kick-off.
DroomieChikito -> Legendary from Sr. Member during Merit System kick-off.
Corrosive -> Hero from Old Era Newbie during Merit System kick-off.
wh1rlw1nd -> Hero from Member during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
Update 17/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: 646.141
Total Txs: 336.854
From Users: 21.974
To Users: 33.710
minDate: 2018-01-24 22:12:21
maxDate: 2020-04-17 02:49:29
Aggregate awarded sMerit for the last complete week (06/04/2020 .. 12/04/2020) is 5.327 which is down 11,75% from the previous week.
In addition, there are 2 more Legendary and 2 more Hero members this week:
dannybrown -> Legendary from Sr. Member during Merit System kick-off.
tyKiwanuka -> Legendary from Full Member during Merit System kick-off.
Bthd -> Hero from Old Era Newbie during Merit System kick-off.
Paolo.Demidov -> Hero from Old Era Newbie 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: 646.141
Total Txs: 336.854
From Users: 21.974
To Users: 33.710
minDate: 2018-01-24 22:12:21
maxDate: 2020-04-17 02:49:29
Aggregate awarded sMerit for the last complete week (06/04/2020 .. 12/04/2020) is 5.327 which is down 11,75% from the previous week.
In addition, there are 2 more Legendary and 2 more Hero members this week:
dannybrown -> Legendary from Sr. Member during Merit System kick-off.
tyKiwanuka -> Legendary from Full Member during Merit System kick-off.
Bthd -> Hero from Old Era Newbie during Merit System kick-off.
Paolo.Demidov -> Hero from Old Era Newbie during Merit System kick-off.
Note:
Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
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.
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.
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?
Jump to: