Merit DashboardThe dashboard gives you
access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:
BitcoinTalk Merit Dashboard.
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=sharingData as of 06/09/2024: Updated the Merit Dashboard to reflect the most recent sMerit available data:
Total sMerit: 1.878.313
Total TXs: 999.320
From Users: 25.826
To Users: 48.568
minDate: 2018-01-24 22:12:21
maxDate: 2024-09-06 02:34:45
New: added Matrix Tab (last Tab) to reflect and update this analysis:
Merited on multiple Subsections and the Correlation MatrixMerit Race per board (only adding Merits on that board) - selectable users..
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2Fhaoboq1.png&t=665&c=1WZGrX4sKZ5tng)
-> Does not reorder positions, and frames are months.
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.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FriLC7Nn.png&t=665&c=x8qU0_Zdb5cXtQ)
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_linkNote: 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. Merit per post on the Merit DashboardI’ve added the above table, with all the full 14 months of data to the Merit Dashboard (last 2 Tabs). There, you can play around with the filters to:
- Delimit the comparison to a set of specific boards.
- Delimit the months (i.e. exclude abnormal values).
The output is something like this:
https://public.tableau.com/views/BitcointalkMeritDashboard/MeritperPost?:display_count=y&:origin=viz_share_link
https://public.tableau.com/views/BitcointalkMeritDashboard/MeritperPostIIChart?:display_count=y&:origin=viz_share_linkFull description here:
Merit per post per board IIAdded 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:
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FYSCHyb9.png&t=665&c=BlsimCNki8PAMg)
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).
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-Created a couple of Tabs to show a Wordcloud with who merited you and whom you merited.
-Created Tab to view the total number of Merit Senders and Receivers forum wide (see
sMerit participants – a worrying descending trend (!/?)).
-Created Tab to view Merit Streaks (see
Received Merit - Top Streaks (merited days in a row) - Updated).
-Created Tab to compare post evolution on local boards (see
Analysis – Net Post evolution in all Local Boards).
Note: If anyone wants to know how many merits they earned per day (as opposed to per month) and/or when was the last time so and so merited someone or vice-versa (or see the merits received per month from such and such), that is achievable through the Personal Summary Tab (by clicking on meriters/merited names and or changing the view to day or week instead on month). This is pretty powerful, although not trivial to use. If anyone want’s to give it a go and encounters issues, tell me and I’ll detail the process.Edit 11/10/2019:Added a couple of Tabs at the end of the Merit Dashboard to display:
Who merited you (size is proportional to the amount of sMerits they sent you):
https://public.tableau.com/shared/5QX4S5TCQ?:display_count=yes&:origin=viz_share_linkWhom you merited:
https://public.tableau.com/shared/5QX4S5TCQ?:display_count=yes&:origin=viz_share_linkEdit 02/10/2019:I’ve created a new Tab called
Merit Senders /Receivers (fourth from the left) which lets us see most of the information shown in
sMerit participants – a worrying descending trend (!/?), but from a
monthly perspective:
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2F3dUf7mK.png&t=665&c=p_5-Oid7Kf46aw)
The novel elements are nFromUsers (Senders) which represents the total number of distinct users that sent sMerit on a given month, and nToUsers (Receivers) which is the total number of distinct recipients of sMerit in a given month.
- If we apply no filters, we get the general forum-wide overview.
- We can filter by UserFromName (or Id), to see the amount of distinct people we merit per month.
- Likewise, filtering by UserToName (or Id) will display the number of distinct people that have merited that profile.
- Similarly, applying the Section/Subsection filter allows us to see the number of meriters and merited by that concept (i.e. local board).
Edit 09/11/2018:I added by request a filter on the Ranked-up Tab (called "subsection (choose one)"). This filter was non-trivial, and on this tab has the semantics of filtering the ranked-up users to those with at least 1 received sMerit in the selected Subsection.
This is very useful for local boards, as for example filtering by subsection “French” will show all users that have ranked-up needing merit, and that have received at least 1 sMerit in the French Local board. It is very likely that these users are therefore French (or affinities), and thus is a way of seeing who has ranked-up on a local board.
Obviously there can be false positives, created by multilingual people who post and get merited on more than one local board. Also locals who only get merited on English board sections only will not be detected as a local of a given language.
Edit 11/10/2018:Tableau has had recent updates, which after a bit of tweaking, now allow the Merit Dashboard to be visible on multiple devices with better fitting. I’ve arranged things around so that
a generic phone device can now be used to view the Merit Dashboard (specially in portrait mode). I may still make arrangements in the following days, since one or two horizontal scrolls are not working yet, and a few other minor things need to be adjusted.
Since the Dashboard often filters when you select a chart bar or a table row, it may not be that easy to get used to it on a mobile, while scrolling around and not accidently activating a filter. I personally prefer a larger screen though, but I think this version is a decent starting point for mobile visualization of the Dashboard.
Edit 09/10/2018:Added a new tab to the Merit Dashboard called "
Merited User Summary". The tab allows you to get a quick visual summary for your profile (or anyone else’s), summarizing the core indicators, summary of sMerits received and sent per month, implied Ranks, and board section/subsections, as well as the users you merit and that have merited you.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FjrDRhP7.png&t=665&c=dxpiIWqo6waDaw)
It’s interesting to click on the images and use them as filters. For example:
- Clicking on a specific Received or Sent month on the charts, adjusts all sections to the data for that month (click again to deselect or use the arrows situated on the bottom right of the screen).
- Clicking on a Specific subsection acts likewise.
- Clicking on a specific From User allows us to see a summary of when that user sent us sMerit, adjusting the month and subsections accordingly. To User works in the same way.
Edit 04/07/2018:Added a Tab called
Reciprocal sMerit which, if used properly, could help to detect Merit Abuse (see my post on this thread:
https://bitcointalk.org/index.php?topic=4428616.msg41487786#msg41487786). The Dashboard has now grown now quite a bit since the initial version...
The dashboard gives you
access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Added this week: Post summary (distribution of sMerit per TX and TXs per post).
Added Recently: De-ranked Users, Potential Merit Sources, User Summary, Section/Subsection, Rankings and WordCloud.
I’ve been considering updating the data of some of my previous analysis. Since the process is rather manual, I thought it would be nice to bring it together into a common Merit Dashboard, in order to keep it all in one place, and to ease the updating process on a more regular basis if necessary. I’ve started off by including what I’ve considered the most relevant information, using a set of tabs to hold the information for a given conceptual vision of the data.
The resulting dashboard is a work in progress, since I will add more features and datasets whenever possible. To mention that I do prefer the colours on my previous analytical posts (black background on the graphs), but for now the dashboard will have a white background since I’m concentrated on content and a little bit less on aesthetics.
The dashboard requires no installation, but it does result to java script (so it must be enabled in order for it to work).
Note: Screen shots show up with certain date information based on my local settings. If this works correctly, the actual Merit Dashboard should work based on your local setings... (dates and number formats, not captions). The dashboard has the following Tabs:
1. Global Summary: ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FQlC1Jet.jpg&t=665&c=Sk9FE4CizVq4IA)
Shows a summary of how merit is awarded, broken down by:
- Week (Monday to Sunday- on previous analysis I may have used Sunday to Saturday since it’s the default in the software I use for data crunching).
- Day of the Week.
- Hour (UTC – This is not too important, but some merit awarding varies by date depending for example if the data is UTC, UTC-6 or UTC+6).
- Weekly Ratios I’ve used before, including total aggregates at the top of the table.
Since the data originated in the public merit.txt file is published on Friday mornings, the data to the most recent week is partial (lacking most of Friday, as well as Saturday and Sunday). The rest of the weeks are complete.
We can see a clear weekly downtrend again since the end of April onwards after a light recovery in the last fortnight of April.
We already knew that Thursday is the most merited day and that UTC 8-20h are the most merited hours of the day.
New weekly users that receive Merit are around the 25%-27% area (so every week roughly one quarter of merited users are merited for the first time -> see %ToNew in the Weekly Ratios).
2. From/To Ranks![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FRmAhLV8.jpg&t=665&c=jeDUcXvPnOxLmQ)
Shows which ranks merit which ranks both in absolute value (number of awarded merits) and relative values (% of awarded merits per “from rank” to each “to rank”).
This is similar to
Which Ranks send sMerit to which Ranks - and who ranked up, but now updated.
Comparing current data to the analysis above stated, we can see for example that:
- Legendaries keep roughly the same awarding proportions overall as they had around end of march, being the most favourable movement increase for Jr. Members (4,37% -> 6,18%).
- Heroes keep nearly the exact proportions as end of March.
- Sr. Member have dropped their awarding rate to Sr. Members (23,15% -> 20,56%) and have moved the drop to Members (23,02%->24,46%) and Jr. Members (6,57%-> 7,28%).
- Full members have dropped a bit on their ratio of awarding full members (31,74%->29,52%), moving the difference to Members (26,69% -> 29,57%).
- Members awarding to Full Members has moved from 20,26% to 17,15%, being Members the most favoured increase (42,92%-> 47,07%).
- Jr. Members now favour less Full Members than before (19,48% -> 14,01%), but increase the Newbies rank (4,22% -> 8,62%).
All in all there are slight changes, but not too significant.
Note that the rank is derived from the current user profile, and not at the time of actual awarding which may have been different (we cannot access the rank at time of awarding, so this is the next best thing we can use).3. Received Merit![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2Fip8UhhC.jpg&t=665&c=3duwxJUhkhBQAw)
Shows the overall received Merit breaking it down by the Ranks that send it, month, specific date and user names along with the aggregate quantity they’ve sent.
By default, the data shown is the overall merit, but you can filter by user name/s to delimit the view to a specific user set (i.e. filter by your own username to see the merit you received).
4. Sent Merit![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FrHvM0Us.jpg&t=665&c=_lfFL-2ac9N2nQ)
Shows the overall sent Merit breaking it down by the Ranks the merit has been sent to, month, specific date and user names along with the aggregate quantity they’ve received.
By default, the data shown is the overall merit, but you can filter by user name/s to delimit the view to a specific user set (i.e. filter by your own username to see the merit you sent).
5. Ranked-up![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2Fof7LniJ.jpg&t=665&c=et86ZPYQWHth0w)
This gives us the amount of users that have ranked-up using the new merit system, indicating their starting rank and current rank. This is similar to what I’ve done before numerically in posts. To see a specific set it is easier to filter by (probable) initial rank and current rank.
I’ve omitted including combinations relative to ranks that are not amongst the conventional ranks that need merit to rank-up. There are even some de-ranked cases (omitted), probably caused by purchasing an account and deleting the posts.
6. Ranking-up pipeline![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FOKtw0wL.jpg&t=665&c=Disb8zje-wrctw)
This gives us a global vision of how many users are depending on what (activity, merit, both) in order to rank-up. This only considers users that have been awarded Merit (in at least 1 Merit TX), not those that had a Merit airdrop and have not received any further Merit.
This is similar to
Stats on the Rank pipeline - How many are we on the way to ranking up? extensionComparing the above mentioned analysis (created during mid-April 2018) to current dashboard data, we can see that:
- We’ve gone from 135 to 219 Heroes that could have ranked-up, but lack Merit.
- We’ve gone from 297 to 444 Sr. Members that could have ranked-up, but lack Merit.
- We’ve gone from 1.146 to 1.919 Full Members have not ranked-up due to lack of Merit (by contrast, those lacking both activity and merit have decreased 1.458 -> 911).
- We’ve gone from 2.032 to 2.711 Members that could have ranked-up, but lack Merit.
- We’ve gone from 1.914 to 2.460 Members that could have ranked-up, but lack Merit.
In summary, merit is slowing down the ranking process (as we already knew), and candidates awaiting “just” to earn merits in order to rank-up are greater by number.
7. TXs.![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2F7rjSvUW.jpg&t=665&c=N6a8epn4LGKZCw)
A list of all the Merit Transactions. The idea here is to filter by User From Name or User To name to see all Tx history for a given user/s. This can also be done on the Merit Network.
8. Merit Network![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FOvj50oL.jpg&t=665&c=YsPaaitskrcKEw)
This should contain and embedded link to
Our very own sMerit Network Picture - enhanced with access to all sMerit TXs.
Unfortunately, I can see the embedded webpage fine in development, but not once I view the published Merit Dashboard. Until I find a solution (if there is one, which I’m not too positive about), I’ve placed a button that takes us there.
Dashboard Usage:![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2F7AWxqpZ.jpg&t=665&c=9-9TpkWVEreytQ)
Using the dashboard is pretty straight forward. It may be good to mention that:
If you scroll down you’ll find a very useful toolbar that allows you to:
- (<-) Undo if you apply a filter to the data and cannot revert easily to the previous unfiltered situation.
- (-> )Redo.
- (rectangle with a downward arrow) Save as image or pdf.
- (rectangle) Full Screen.
- (ESC) Exit Full Screen.
Also, when applying a filter (for example in the Received Merit Tab), you can type in the name and press the plus sign to add the name to the filter (multiple names are allowed), or use the magnifier to search for all name that contain the typed string (and then select the desired names).
To delete a filter you can hover over the filter value until a cross sign appears to delete the item, or use the undo arrow on the toolbar mentioned above.