Bitcointalk Merit Dashboard

[giammangiato]

very nice work done here ddmrddmr
Well done

I came to know about this place thanks to "fillippone" who shares some of your content with us

thank you for this work you have done

[1714513281]

1714513281

[1714513281]

1714513281

[1714513281]

1714513281

[1714513281]

1714513281

[1714513281]

1714513281

[1714513281]

1714513281

[fillippone]

I just completed my monthly overview of the Italian board.
I am just wondering if there is a smart way to compute the “merited post percentage”, defined as the percentage of post that gained at least one merit over the total amount of post, for each board.

I tried to play a little with the dashboard and I think the best is doing the sum of all he merited post in the “ Number of Merit TXs per post” for each board, but I feel there could be a smarter way to do that.

[DdmrDdmr]

<...>

I’ve added a column to the "Merit per Post" tab called nMeritedPosts, that counts the distinct number of posts merited within the given board and month.

Notice that the toll is counting the number of posts that have been merited withing the meriting timeframe, not withing the posting timeframe. That is to say, I’m counting based on when the meriting event takes place, not when the posting event takes place.

Note: I'm updating the Dashboard now. Give it 5-10 minutes or so to complete.

Note2: Weird side-effect: updating the board seems to have replaced the whole Dashboard with a Viz (single tab). I’ll try to look into it later on. Solved.


Edit 20230604:
The next Merit Dashboard update will be delayed a few days. I’ll probably manage to do it next Tuesday/Wednesday (instead of this Friday).

[fillippone]

Notice that the toll is counting the number of posts that have been merited withing the meriting timeframe, not withing the posting timeframe. That is to say, I’m counting based on when the meriting event takes place, not when the posting event takes place.

Thank you. The way it work it is logical and that is exactly as intended.
Maybe it's too late here, but still see some wired behaviour on that tab (it's impossible to unfiltered a column, once you select a sorting criteria).

[DdmrDdmr]

<…> still see some wired behaviour on that tab (it's impossible to unfiltered a column, once you select a sorting criteria).

I really don’t have much control over the sorting capabilities. I’ve played around with the sorting capabilities on the tab for a while, and I’m not sure exactly what you are encountering. If you’d like to provide a user case, so that I replicate the behaviour, I’ll get a better grasp of the issue.

[fillippone]

<…> still see some wired behaviour on that tab (it's impossible to unfiltered a column, once you select a sorting criteria).

I really don’t have much control over the sorting capabilities. I’ve played around with the sorting capabilities on the tab for a while, and I’m not sure exactly what you are encountering. If you’d like to provide a user case, so that I replicate the behaviour, I’ll get a better grasp of the issue.

It's something I never realised, but it's spread all over the dashboard, not only in this particular tab.

How can I revert the "Keep Only" choice, when highlighting a particular value to go back to the whole list?





It's something I am sure I have done in the past, but I now cannot do that. Maybe it's the recent Tableau upgrade?

[DdmrDdmr]

<...>

There’s the old <CTRL>+Z to take the filtered selection one step back at a time, and at the bottom right of the screen the left pointing arrow "<-" should perform the same action. There’s also an icon similar to "|<-" which undoes all the steps altogether, and should therefore revert the filters to a situation similar to when you load the dashboard for the first time in the session.

[fillippone]

<...>

There’s the old <CTRL>+Z to take the filtered selection one step back at a time, and at the bottom right of the screen the left pointing arrow "<-" should perform the same action. There’s also an icon similar to "|<-" which undoes all the steps altogether, and should therefore revert the filters to a situation similar to when you load the dashboard for the first time in the session.

Thanks for pointing out. I was using floating windows, so I missed the bottom right controls!
Everything works as intended.
Thanks for the continuous support @ddmrddmr.

[DdmrDdmr]

Update 07/04/2023:

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: 1.471.832
Total TXs:       785.204
From Users:     24.982
To Users:         45.708
minDate:        2018-01-24 22:12:21
maxDate:       2023-04-07 02:51:31

Aggregate awarded sMerit for the last complete week (27/03/2023 .. 02/04/2023) is 5.971, which is up 16,12% from the previous week.

There are 5 new Legendary members and 7 new Hero Members this week.

bakasabo              -> Legendary from Old Era Newbie during Merit System kick-off.
Best_Change         -> Legendary from New Era Newbie during Merit System kick-off.
holydarkness         -> Legendary from Hero Member during Merit System kick-off.
JeromeTash           -> Legendary from Full Member during Merit System kick-off.
Polkeins               -> Legendary from Old Era Newbie during Merit System kick-off.


_act_                -> Hero Member from New Era Newbie during Merit System kick-off.
Agbe                 -> Hero Member from New Era Newbie during Merit System kick-off.
Gencecikmen     -> Hero Member from New Era Newbie during Merit System kick-off.
internetional       -> Hero Member from New Era Newbie during Merit System kick-off.
Inwestour          -> Hero Member from New Era Newbie during Merit System kick-off.
MA40                 -> Hero Member from Sr. Member during Merit System kick-off.
uchegod-21       -> Hero Member from New Era Newbie during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.

[DdmrDdmr]

Update 14/04/2023:

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: 1.478.180
Total TXs:       788.606
From Users:     24.991
To Users:         45.755
minDate:        2018-01-24 22:12:21
maxDate:       2023-04-14 02:41:02

Aggregate awarded sMerit for the last complete week (03/04/2023 .. 09/04/2023) is 7.228, which is up 21,05% from the previous week.

There are no new Legendary members but 2 new Hero Members this week.

Becassine                   -> Hero Member from Member during Merit System kick-off.
conilmionome              -> Hero Member from New Era Newbie during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.

[giammangiato]

thanks for the updates
I started seeing this dashboard very often
it is very beautiful and full of data, you can understand a lot by looking at the graphs

thank you   when i deserve, some are yours guaranteed

[fillippone]

Hello my friend.
I know it has been a busy day for you, but can you please check the reciprocal merit spreadsheet?
https://docs.google.com/spreadsheets/d/12G0JE1HVX9McRQT9oNflZ-FDavhEOzDXxRyNm4rnfZs/edit#gid=1880411232

I see only 88 merits exchanged on the Italian board this month, while they should be higher, of course.


Sorry if I post this message here, but I wasn't able to find the OP where you disclosed the release of this spreadsheet.

[DdmrDdmr]

<…>

I briefly remember I had to update it after I had the month’s complete data … but forgot to do it (again) nevertheless.

It’s now updated with data running up to last Friday (april 2023 is therefore partial).

[fillippone]

<…>

I briefly remember I had to update it after I had the month’s complete data … but forgot to do it (again) nevertheless.

It’s now updated with data running up to last Friday (April 2023 is therefore partial).

My monthly update for the Italian board involves three  Google sheet files, 20 images and a lot of writing. I guess your weekly updates involve more files (you once states the weekly update involves 12 different files). Plus those “random” files. Looks like a lot of work! It’natural that sometime a mishap stops the machine!

[DdmrDdmr]

Update 21/04/2023:

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: 1.484.851
Total TXs:       792.371
From Users:     25.006
To Users:         45.788
minDate:        2018-01-24 22:12:21
maxDate:       2023-04-21 02:51:32

Aggregate awarded sMerit for the last complete week (10/04/2023 .. 16/04/2023) is 6.258, which is down 13,42% from the previous week.

There are 1 new Legendary member and 2 new Hero Members this week.

Disruptivas                   -> Legendary  from New Era Newbie during Merit System kick-off.
Ondekinecakabilirim      -> Hero Member from New Era Newbie during Merit System kick-off.
yudi09                          -> Hero Member from Sr. Member during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.

[DdmrDdmr]

Update 28/04/2023:

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: 1.490.832
Total TXs:       795.902
From Users:     25.019
To Users:         45.818
minDate:        2018-01-24 22:12:21
maxDate:       2023-04-28 02:51:22

Aggregate awarded sMerit for the last complete week (17/04/2023 .. 23/04/2023) is 6.525, which is up 4,27% from the previous week.

There are 2 new Legendary members and 2 new Hero Members this week.

Lucasgabd                         -> Legendary  from Full Member during Merit System kick-off.
somac.                               -> Legendary  from Full Member during Merit System kick-off.
borovichok                         -> Hero Member from Full Member during Merit System kick-off.
MarjorieZimmermanGinger   -> Hero Member from Full Member during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.

[Halab]

Is it me but I don't see any tabs anymore, there is just the Global Summary page.

[DdmrDdmr]

<...>

It’s done that as of late a couple of times, reverting a setting out of the blue that enables for the tabs to be viewed. It’s fixed now.

[DdmrDdmr]

Update 05/05/2023:

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: 1.496.498
Total TXs:       798.900
From Users:     25.034
To Users:         45.854
minDate:        2018-01-24 22:12:21
maxDate:       2023-05-05 02:51:02

Aggregate awarded sMerit for the last complete week (24/04/2023 .. 30/04/2023) is 5.829, which is down 10,67% from the previous week.

There are 1 new Legendary member and 2 new Hero Members this week.

tg88                               -> Legendary  from Full Member during Merit System kick-off.
Zlantann                         -> Hero Member from New Era Newbie during Merit System kick-off.
Z-tight                            -> Hero Member from New Era Newbie during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.


Edit:

<…>

Thanks. I’ve now taken it into account, though in my case, the only place this detail level appears is in the "Local Board post count evolution" tab. There, I derive the data from a snapshot of the forum’s monthly stats, which are not modified retrospectively for obvious reasons. Changes will therefore be move visual next month, though historical month’s data won’t get its subsection reassigned.

[indah rezqi]

DdmrDdmr, I have to tell you that starting in May our local board (Bahasa Indonesian) has got 3 new sub-boards including:

1. Trading dan Spekulasi
2. Ekonomi, Politik, dan Budaya
3. Topik Lainnya

I think you need to adjust these additions at your great tool (Bitcointalk Merit Dashboard), so that the data displayed is in accordance with the latest. Just it. TryNinja should also pay attention to that in my opinion for Ninjastic.space.