Pages:
Author

Topic: Bitcointalk Merit Dashboard - page 12. (Read 39911 times)

legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
June 24, 2022, 05: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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
June 17, 2022, 01: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: 2380
Merit: 17063
Fully fledged Merit Cycler - Golden Feather 22-23
June 11, 2022, 01: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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
June 11, 2022, 10: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: 2380
Merit: 17063
Fully fledged Merit Cycler - Golden Feather 22-23
June 11, 2022, 08: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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
June 10, 2022, 01: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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
June 03, 2022, 01: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: 4326
Merit: 8950
'The right to privacy matters'
June 01, 2022, 07: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: 2380
Merit: 17063
Fully fledged Merit Cycler - Golden Feather 22-23
June 01, 2022, 04: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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
June 01, 2022, 09: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: 2380
Merit: 17063
Fully fledged Merit Cycler - Golden Feather 22-23
June 01, 2022, 07: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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
May 27, 2022, 04: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.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
May 20, 2022, 01:08:24 AM
Update 20/05/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.195.493
Total TXs:       646.775
From Users:     24.336
To Users:         43.435
minDate:        2018-01-24 22:12:21
maxDate:       2022-05-20 02:48:41

Aggregate awarded sMerit for the last complete week (09/05/2022 .. 15/05/2022) is 5.004, which is down 9,31% from the previous week.

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

Cryptmuster   -> Hero Member from Full Member during Merit System kick-off.
Hispo             -> Hero Member from New Era Newbie during Merit System kick-off.
so98nn           -> 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.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
May 13, 2022, 05:07:16 AM
Update 13/05/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.190.208
Total TXs:       643.889
From Users:     24.322
To Users:         43.351
minDate:        2018-01-24 22:12:21
maxDate:       2022-05-13 02:37:29

Aggregate awarded sMerit for the last complete week (02/05/2022 .. 08/05/2022) is 5.518, which is down 8,78% from the previous week.

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

Sayeds56              -> Hero Member from New Era Newbie during Merit System kick-off.
UmerIdrees           -> Hero Member 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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
May 06, 2022, 01:33:14 AM
Update 06/05/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.185.111
Total TXs:       641.155
From Users:     24.310
To Users:         43.294
minDate:        2018-01-24 22:12:21
maxDate:       2022-05-06 02:51:36

Aggregate awarded sMerit for the last complete week (25/04/2022 .. 01/05/2022) is 6.049, which is up 18,03% from the previous week.

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

BlackHatCoiner          -> Legendary from New Era Newbie during Merit System kick-off.
RickDeckard              -> 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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
April 29, 2022, 01:09:01 AM
Update 29/04/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.178.879
Total TXs:       637.950
From Users:     24.290
To Users:         43.223
minDate:        2018-01-24 22:12:21
maxDate:       2022-04-29 02:36:00

Aggregate awarded sMerit for the last complete week (18/04/2022 .. 24/04/2022) is 5.125, which is up 7,85% from the previous week.

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

Rruchi man          -> Legendary from New Era Newbie during Merit System kick-off.
sam00                 -> 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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
April 22, 2022, 01:16:02 AM
Update 22/04/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.173.525
Total TXs:       635.352
From Users:     24.274
To Users:         43.175
minDate:        2018-01-24 22:12:21
maxDate:       2022-04-22 02:42:02

Aggregate awarded sMerit for the last complete week (11/04/2022 .. 17/04/2022) is 4.752, which is down 17,53% from the previous week.

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

GazetaBitcoin          -> Legendary from New Era Newbie during Merit System kick-off.
wolwoo                   -> Legendary 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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
April 15, 2022, 01:21:55 AM
Update 15/04/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.169.023
Total TXs:       632.698
From Users:     24.258
To Users:         43.120
minDate:        2018-01-24 22:12:21
maxDate:       2022-04-15 02:45:31

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

There are no new Legendary nor Hero Members this week.

Note:
-Copper Members and non-native ranks (staff, etc) are displayed as real (regular) ranks.
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
April 08, 2022, 01:35:39 AM
Update 08/04/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.163.402
Total TXs:       629.543
From Users:     24.240
To Users:         43.035
minDate:        2018-01-24 22:12:21
maxDate:       2022-04-08 02:25:09

Aggregate awarded sMerit for the last complete week (28/03/2022 .. 03/04/2022) is 6.531, which is down 0,38% from the previous week.

In addition, there are 1 new Legendary and 1 new Hero Members this week.

Coyster          -> Legendary from New Era Newbie during Merit System kick-off.
ZekiBeyy        -> 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: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
April 01, 2022, 01:43:05 AM
Update 01/04/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.157.473
Total TXs:       626.441
From Users:     24.222
To Users:         42.985
minDate:        2018-01-24 22:12:21
maxDate:       2022-04-01 02:47:32

Aggregate awarded sMerit for the last complete week (21/03/2022 .. 27/03/2022) is 6.556, which is down 0,43% from the previous week.

In addition, there are 1 new Legendary and 1 new Hero Members this week.

Slow death          -> Legendary from Hero Member during Merit System kick-off.
m2017               -> Hero Member from Member during Merit System kick-off.


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