Pages:
Author

Topic: Bitcointalk Merit Dashboard - page 9. (Read 38390 times)

legendary
Activity: 2464
Merit: 2094
August 11, 2022, 11:11:23 PM
@DdmrDdmr, looks like this is the first time I've seen the number of posts on local Indonesian boards experiencing too many minuses in various sub boards. I'm a bit confused to find the reason why, because while there were 835 posts made during the month of July on a local board based on the ninjastic.space tool by 74 users so I have to make two charts about this for the month of July. Re: [CHART] Tampilan Bulanan Aktivitas Lokal Board Bahasa Indonesia

Can I get some of the reasons?

legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
August 05, 2022, 06:32:53 AM
Update 05/08/2022:

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.261.781
Total TXs:       680.383
From Users:     24.471
To Users:         43.980
minDate:        2018-01-24 22:12:21
maxDate:       2022-08-05 02:37:56

Aggregate awarded sMerit for the last complete week (25/07/2022 .. 31/07/2022) is 4.784, which is down 17,32% from the previous week.

There are 1 new Legendary, and 1 new Hero Members this week.

bbc.reporter         -> Legendary from Hero Member during Merit System kick-off.
MK-74                -> 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.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
July 29, 2022, 03:19:31 AM
Update 29/07/2022:

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.256.059
Total TXs:       677.721
From Users:     24.464
To Users:         43.930
minDate:        2018-01-24 22:12:21
maxDate:       2022-07-29 02:49:45

Aggregate awarded sMerit for the last complete week (18/07/2022 .. 24/07/2022) is 5.786, which is down 11,70% from the previous week.

There are 1 new Legendary, and 1 new Hero Members this week.

FatFork                -> Legendary from New Era Newbie during Merit System kick-off.
ZipReg                -> Hero Member from Member during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
July 22, 2022, 02:22:21 AM
Update 22/07/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.251.225
Total TXs:       675.209
From Users:     24.457
To Users:         43.890
minDate:        2018-01-24 22:12:21
maxDate:       2022-07-22 02:50:25

Aggregate awarded sMerit for the last complete week (11/07/2022 .. 17/07/2022) is 6.553, which is up 16,77% from the previous week.

There are no new Legendary, but 3 new Hero Members this week.

Mahdirakib                     -> Hero Member from Full Member during Merit System kick-off.
realdantreccia                -> Hero Member from Old Era Newbie during Merit System kick-off.
SquirrelJulietGarden      -> 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.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
July 15, 2022, 02:21:43 AM
Update 15/07/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.244.160
Total TXs:       671.407
From Users:     24.448
To Users:         43.844
minDate:        2018-01-24 22:12:21
maxDate:       2022-07-15 02:50:16

Aggregate awarded sMerit for the last complete week (04/07/2022 .. 10/07/2022) is 5.612, which is down 13,77% from the previous week.

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

Charles-Tim            -> Legendary from New Era Newbie during Merit System kick-off.
serveria.com           -> Legendary from Old Era Newbie during Merit System kick-off.

CLS63                     -> Hero Member from Full Member during Merit System kick-off.
Fivestar4everMVP    -> 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.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
July 08, 2022, 02:25:26 AM
Update 08/07/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.238.619
Total TXs:       668.658
From Users:     24.443
To Users:         43.800
minDate:        2018-01-24 22:12:21
maxDate:       2022-07-08 02:38:07

Aggregate awarded sMerit for the last complete week (27/06/2022 .. 03/07/2022) is 6.508, which is up 15,23% from the previous week.

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

-doubleU-      -> Legendary from Member during Merit System kick-off.
btc_angela     -> Hero Member from Sr. Member during Merit System kick-off.
gagux123       -> 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.

legendary
Activity: 2464
Merit: 2094
July 01, 2022, 07:20:09 AM
I'm happy to see that 3 local board Bahasa Indonesia users managed to rank up during June 2022. There are two new Legendary (kawetsriyanto and Falconer) and 1 Hero (mamesso). All three of these users are quite active on the local boards with their contributions, so we should be glad they rank up last month. Congratulations to the three users above, they deserve to move up the rankings. I hope there are more users who can rank up after this on the local board Bahasa Indonesia.

In addition, I also saw an increase in the distribution of merit that occurred during April to June. That increase is something we were hoping for after earlier in the year we kept the 500+ merit.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
July 01, 2022, 02:29:31 AM
Update 01/07/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.232.309
Total TXs:       665.430
From Users:     24.431
To Users:         43.741
minDate:        2018-01-24 22:12:21
maxDate:       2022-07-01 02:35:12

Aggregate awarded sMerit for the last complete week (20/06/2022 .. 26/06/2022) is 5.648, which is down 12,89% from the previous week.

There are no new Legendary, but 3 new Hero Members this week.

Disruptivas   -> Hero Member from New Era Newbie during Merit System kick-off.
mamesso     -> Hero Member from Sr. Member during Merit System kick-off.
Raflesia       -> 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.

legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
June 24, 2022, 06:06:48 AM
Update 24/06/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.226.572
Total TXs:       662.621
From Users:     24.417
To Users:         43.692
minDate:        2018-01-24 22:12:21
maxDate:       2022-06-24 02:25:07

Aggregate awarded sMerit for the last complete week (13/06/2022 .. 19/06/2022) is 6.484, which is up 11,89% from the previous week.

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

Falconer              -> Legendary from Hero Member during Merit System kick-off.
MrCryptHodl       -> 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.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
June 17, 2022, 02:58:47 AM
Update 17/06/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.220.295
Total TXs:       659.307
From Users:     24.399
To Users:         43.628
minDate:        2018-01-24 22:12:21
maxDate:       2022-06-17 02:31:27

Aggregate awarded sMerit for the last complete week (06/06/2022 .. 12/06/2022) is 5.795, which is down 17,93% from the previous week.

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

kawetsriyanto              -> Legendary from New Era Newbie during Merit System kick-off.
shahzadafzal               -> Legendary from Old Era Newbie during Merit System kick-off.


Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
legendary
Activity: 2114
Merit: 15144
Fully fledged Merit Cycler - Golden Feather 22-23
June 11, 2022, 02:13:05 PM
<..>

I’ve updated the Dashboard to resolve the 25 buggy merit discrepancy. The difference should therefore only be the 168 deleted merits.

We both know how to have fun on a lazy June Saturday afternoon, after all!

I had the suspect it had to do with the deleted posts. I think I will go with the "Merit per Post" tab, not to include deleted posts.

Thanks for taking care of this issue and fixing it.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
June 11, 2022, 11:39:57 AM
<…>
The Merit Senders/Receivers tab includes all boards + a virtual “deleted” board, which is not present in the Merit/post tab nor calculus. That accounts for what should be all the difference in the figures, but debugging the info I found some other minor issue:

•   May has a total of 168 Merits awarded to now deleted posts.

•   Bitcoin Discussion in Merit Senders/Receivers: 2.147 (correct)
•   Bitcoin Discussion in Merit per post: 2.150 (wrong)

•   Trading Discussion in Merit Senders/Receivers: 879 (correct)
•   Trading Discussion in Merit per post: 901 (wrong)


So the difference is down to:

24707 in Merit Senders/Receivers
   -168 Deleted
      -3 Bitcoin Discussion
    -22 Trading Discussion
-----------------------------
24564 in Merits per post


Now the deleted is a difference in inclusion criteria and calculus between the tabs, as stated. But the other 25 Merits were strange, and likely related to the order of scripts in my updates this month. I’ve rerun some of the scripts and it gives the correct results now.


I’ve updated the Dashboard to resolve the 25 buggy merit discrepancy. The difference should therefore only be the 168 deleted merits.
legendary
Activity: 2114
Merit: 15144
Fully fledged Merit Cycler - Golden Feather 22-23
June 11, 2022, 09:42:12 AM
You have probably already answered to this question, but I wasn't able to find it in this thread.
What is the cause of the discrepancy on the number of total merits at forum level in May in the "Merit per Post" table (24,564) compared to the "Merit Senders and Receivers" table (24,707).
At the italian level I don't see any discrepancy (542 in both tabs), so wondering if something is missing or there is a different methodology for the two tabs.
Thanks!
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
June 10, 2022, 02:07:48 AM
Update 10/06/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.213.886
Total TXs:       655.771
From Users:     24.384
To Users:         43.562
minDate:        2018-01-24 22:12:21
maxDate:       2022-06-10 02:19:50

Aggregate awarded sMerit for the last complete week (30/05/2022 .. 05/06/2022) is 7.061, which is up 16,60% from the previous week.

There are no new Legendary but 1 new Hero Members this week.

Rizzrack              -> 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.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
June 03, 2022, 02:24:41 AM
Update 03/06/2022:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
LinkBitcoinTalk Merit Dashboard

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit: 1.208.280
Total TXs:       652.762
From Users:     24.365
To Users:         43.522
minDate:        2018-01-24 22:12:21
maxDate:       2022-06-03 02:40:53

Aggregate awarded sMerit for the last complete week (23/05/2022 .. 29/05/2022) is 6.056, which is up 10,67% from the previous week.

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

$icopress$              -> Legendary from Member during Merit System kick-off.
safar1980              -> Legendary from New Era Newbie during Merit System kick-off.

Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
legendary
Activity: 4102
Merit: 7765
'The right to privacy matters'
June 01, 2022, 08:57:12 PM


Give it a go and let's see if it works as intended ...


It works.
It's not so simple to create a pivot as intended, but I'm working on it.
Due to  the empty bottle of wine exceptional circumstances I won't be able to produce it by tonight, but I'm going to work something out.

Well I just knocked off a bottle of red cab so I feel you.
legendary
Activity: 2114
Merit: 15144
Fully fledged Merit Cycler - Golden Feather 22-23
June 01, 2022, 05:02:51 PM


Give it a go and let's see if it works as intended ...


It works.
It's not so simple to create a pivot as intended, but I'm working on it.
Due to  the empty bottle of wine exceptional circumstances I won't be able to produce it by tonight, but I'm going to work something out.
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
June 01, 2022, 10:30:00 AM
<…>
I tried to include a couple of free export add-ons to the Dashboard, but freebies on the Public Version I’m using are pretty bad, and they didn’t really manage to export all the fields (i.e. calculated fields were skipped).

In light of the above, I’ve now opened the Merit Dashboard for anyone who wants to download it, thus being able to manipulate it in their own environment, and accessing a full range of features such as the Export to CSV feature (Data-> Chose a source (i.e. Merit per post) -> Export to csv).

The above should do the trick, as you can now access all the Data sources I use (some are raw, others are pre-cooked from the raw data).

The Merit Dashboard should now allow you to click the download link, downloading a copy of the Merit Dashboard onto your device (some 49Mb only). You can then open it with your local installation of Tableau Public and access the Data as mentioned above.

Give it a go and let's see if it works as intended ...
legendary
Activity: 2114
Merit: 15144
Fully fledged Merit Cycler - Golden Feather 22-23
June 01, 2022, 08:31:15 AM
Hello @ddmrddmr,

I wondered if there is a way to download some of the outputs of your tabs to Google sheets to process them to obtain some more information.

For example, I would like to collect the total number of posts and merits for each local board, but I failed to export them to Google sheets. I even tried installing the tableau app on my laptop.

Do you think it is possible?
legendary
Activity: 2296
Merit: 10753
There are lies, damned lies and statistics. MTwain
May 27, 2022, 05:02:48 AM
Update 27/05/2022:

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.201.511
Total TXs:       649.699
From Users:     24.351
To Users:         43.474
minDate:        2018-01-24 22:12:21
maxDate:       2022-05-27 02:50:23

Aggregate awarded sMerit for the last complete week (16/05/2022 .. 22/05/2022) is 5.472, which is up 9,35% from the previous week.

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

$crypto$              -> Legendary from Hero Member during Merit System kick-off.
machasm             -> 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.
Pages:
Jump to: