A useful user statistic to show - Magic Dust or Emep?

d_eddie

legendary

Activity: 2492

Merit: 2939

Quote from: DdmrDdmr on April 24, 2018, 10:07:18 AM

I’m not sure if the OPs intention in this post is limited to personal indicators, or global stats too. Some simple global indicators in addition to the currently shown could be in the line of:

I was thinking of a personal indicator to be shown under the user's name, along with username, rank, activity and merit. This could be useful both to gauge new faces popping up in discussion, and as an incentive to self improvement.

Quote from: theymos on April 24, 2018, 02:28:45 PM

A major statistical difficulty which I remembered when gathering these is that a lot of people receive merit for pre-merit posts. (Though people who made zero post-merit posts were excluded in the above stats.)

Gathering these stats is slow. It could be tracked live per user, but I'd have to add a lot of caching at various points. I'm probably not going to do it.

Speaking for myself, I'd be glad to suffer some inaccuracy as a tradeoff for server load. Posts created before merit inception should asymptotically go to zero significance anyway. And any 1-D statistic is bound to be inaccurate under the right (wrong?) circumstances. I imagine striking a balance between ease of gathering/computation and capture of useful data is a difficult job in this case.

Quote from: theymos on April 24, 2018, 02:28:45 PM

The weekly tracking is an interesting idea.

It is, even if it only speaks about the overall flow, not about single users. I brought up the last statistic

Code:

(4) latest_merit_increment/latest_activity_increment
(where both increments are within the same 14-day period)

just because I thought that, even if packing less insight, it wouldn't burden the server as much as EMEP. If the number of posts in that period is easy to determine, it would make for a better denominator IMO.

DdmrDdmr

legendary

Activity: 2310

Merit: 10758

There are lies, damned lies and statistics. MTwain

Quote from: theymos on April 24, 2018, 02:28:45 PM

A major statistical difficulty which I remembered when gathering these is that a lot of people receive merit for pre-merit posts. (Though people who made zero post-merit posts were excluded in the above stats.)

Gathering these stats is slow. It could be tracked live per user, but I'd have to add a lot of caching at various points. I'm probably not going to do it.

The weekly tracking is an interesting idea.

If you need anything when you move on, let us know.

The weekly stat is straight from the merit.txt file. For now it is still all included in the 120 day range of the file, although I guess you work directly on the DB so the 4 month limit is not an issue. The mayor difficulty is calculating the nFromNew and nToNew.

In SQL it would be something like:

Code:

select datepart(week,converted_date) Week, sum(amount) nMerit, count(*) nTx, count(distinct user_from) nFrom, t2.nFromNew, count(distinct user_To) nTo, t1.nToNew
from MERIT m1,
(
select datepart(week,converted_date) Week, count(distinct user_To) nToNew
from MERIT m1
where not exists (select 1 from MERIT m2 where m2.user_to = m1.user_to and datepart(week,m2.converted_date) < datepart(week,m1.converted_date))
group by datepart(week,converted_date)
) t1,
(
select datepart(week,converted_date) Week, count(distinct user_from) nFromNew
from MERIT m1
where not exists (select 1 from MERIT m2 where m2.user_from = m1.user_from and datepart(week,m2.converted_date) < datepart(week,m1.converted_date))
group by datepart(week,converted_date)
) t2
where datepart(week,m1.converted_date) = t1.week
and t1.week = t2.week
group by datepart(week,converted_date) , t1.nToNew, t2.nFromNew
order by 1 desc

That's the base. The % ratios are derived in my excercise on the worksheet.

You're right. sMerit awarded to posts existing prior to merit kick off would be a bummer and should probably be excluded from calculations, although then it won´t read all the reality to a 100% degree of accuracy.

theymos

administrator

Activity: 5166

Merit: 12850

Code:

+------------------------+----------+
| User | EMEP |
+------------------------+----------+
| GameKyuubi | 172.0000 |
| BiPolarBob | 52.0000 |
| roll on | 52.0000 |
| negeroy | 51.0000 |
| mthcl | 50.0000 |
| TrollCoins | 50.0000 |
| lfloorwalker | 50.0000 |
| Sunderland | 46.0000 |
| nonnakip | 42.0000 |
| aledesousa | 40.0000 |
| Dropper | 32.0000 |
| TheBobyHunter | 30.5000 |
| synace | 28.0000 |
| popshot | 27.0000 |
| pitipawn | 26.5556 |
| Errror | 25.0000 |
| ParkByte | 25.0000 |
| Eclipse2021 | 25.0000 |
| k453345 | 24.0000 |
| Evil-Knievel | 20.2857 |
| hephaist0s | 20.0000 |
| eBunny6 | 20.0000 |
| davidrus123 | 20.0000 |
| Two-faced | 20.0000 |
| adhd_ | 20.0000 |
| unknownids | 18.3333 |
| Yaremi | 18.0000 |
| romanornr | 17.1111 |
| gmaxwell | 16.6364 |
| theymos | 15.4574 |
| grue | 15.1111 |
| totwotoo2 | 15.0000 |
| QuiveringGibbage | 14.0000 |
| Georgiano | 14.0000 |
| spartak_t | 12.8750 |
| monocolor | 12.7500 |
| John (John K.) | 12.6000 |
| baritus | 12.5000 |
| fedor3327 | 11.5000 |
| koinsever | 11.0000 |
| barisbilgili | 11.0000 |
| vfrcbv911 | 11.0000 |
| Deathwing | 10.2000 |
| AStephen2011 | 10.0000 |
| Nerull | 10.0000 |
| BigWait | 10.0000 |
| kenzie95 | 10.0000 |
| Mr_SeLeNiO | 10.0000 |
| Dexon | 10.0000 |
| winterrose | 10.0000 |
| MikkiRefur | 10.0000 |
| luckyluckybear | 10.0000 |
| hasu | 10.0000 |
| Kumbopulus | 10.0000 |
| Camille_ | 10.0000 |
| SMFSMF5555 | 10.0000 |
| Bitcze | 10.0000 |
| Sergio_Demian_Lerner | 9.0000 |
| dogie | 9.0000 |
| rby | 9.0000 |
| Str1x | 9.0000 |
| VashStampede | 9.0000 |
| semux | 8.8667 |
| Battlestar_Coin | 8.6667 |
| gruve_p | 8.3333 |
| SA Bitcoin Brothers | 8.0000 |
| allahabadialt | 8.0000 |
| God Fist | 7.5000 |
| cryptimus prime | 7.2857 |
| alex bond | 7.2353 |
| analema | 7.1429 |
| Aleksabit | 7.1429 |
| Wingzcrypto2018 | 7.1429 |
| UdjinM6 | 7.0000 |
| publicjud1 | 7.0000 |
| orangepeel | 7.0000 |
| videotek | 7.0000 |
| abegzad | 6.6667 |
| CipherUno | 6.6667 |
| EnF0Rc3r | 6.5000 |
| Ajpa94 | 6.5000 |
| CryptoBridge | 6.2500 |
| tonych | 6.0270 |
| jl777 | 6.0000 |
| gonnafly | 6.0000 |
| wosch76 | 6.0000 |
| charlescoin | 6.0000 |
| ChatBotv2 | 6.0000 |
| batuh007 | 6.0000 |
| cmacwuz | 6.0000 |
| ANNBumping_needed | 6.0000 |
| ErisDiscordia | 5.8571 |
| fengxia | 5.6522 |
| mistercashking | 5.5556 |
| FrozenChaos | 5.5556 |
| Dario3000 | 5.5000 |
| redpepper | 5.5000 |
| Paedy | 5.5000 |
| bitrails | 5.5000 |
| GrowGuildD | 5.4000 |
| Fatanut | 5.2000 |
| Xian01 | 5.0000 |
| bushstar | 5.0000 |
| cloverme | 5.0000 |
| boondogger | 5.0000 |
| sp383 | 5.0000 |
| Financisto | 5.0000 |
| Fuserleer | 5.0000 |
| LucD88 | 5.0000 |
| daniobg | 5.0000 |
| unicornflex | 5.0000 |
| Trukkur | 5.0000 |
| Neo Baudrillard | 5.0000 |
| PokemonGoArena | 5.0000 |
| sherlock_h | 5.0000 |
| Nathan Graves | 5.0000 |
| secretservice | 5.0000 |
| JacquesLeGrande | 5.0000 |
| packetsmurf | 5.0000 |
| plucking23 | 5.0000 |
| bennypagulayan | 5.0000 |
| VazLorde | 5.0000 |
| Delirium07 | 5.0000 |
| haltingprobability | 5.0000 |
| AllarDallar | 5.0000 |
| Msharim | 5.0000 |
| Tobi97l | 5.0000 |
| MetropolisHastings12 | 5.0000 |
| flickernetwork | 5.0000 |
| kryptoholik | 5.0000 |
| CryptoMaps | 5.0000 |
| jooj | 4.7619 |
| RichDaniel | 4.6393 |
| minerbro | 4.6250 |
| Corrosive | 4.6250 |
| Arczimedes | 4.5455 |
| thefiniteidea | 4.5000 |
| ahmedjamal1998 | 4.5000 |
| FIFA worldcup | 4.5000 |
| anjho.ace | 4.5000 |
| hassan.shakeel.rajpoot | 4.5000 |
| everton-1888 | 4.5000 |
| nemgun | 4.4000 |
| costis | 4.4000 |
| thisisntbic | 4.2857 |
| swordfish6975 | 4.2500 |
| DigiByte | 4.2500 |
| LongAndShort | 4.1667 |
| _church | 4.1667 |
| SeverusSnegg | 4.0870 |
| shorena | 4.0556 |
| ziomik | 4.0000 |
| No_2 | 4.0000 |
| Steepdev | 4.0000 |
| Pesmand | 4.0000 |
| kimkibu | 4.0000 |
| Hypocritus | 4.0000 |
| ammo121810 | 4.0000 |
| LindaQ | 4.0000 |
| renriyon | 4.0000 |
| tizzle81 | 4.0000 |
| syavca | 4.0000 |
| Tunjevina | 4.0000 |
| Cryptobitminer | 4.0000 |
| Marec4 | 3.9375 |
| batesresearch | 3.9286 |
| brianmct | 3.9231 |
| Seapork | 3.9091 |
| Dr.Mann | 3.8065 |
| AZwarel | 3.7500 |
| BitcoinHomework | 3.7500 |
| NLNico | 3.7391 |
| marlais | 3.6667 |
| Shymko | 3.6000 |
| maldini | 3.5714 |
| tam31 | 3.5000 |
| CryptoSangria | 3.5000 |
| saulzaents | 3.4861 |
| truckinusa44 | 3.4375 |
| heratys111 | 3.3889 |
| dorianm421 | 3.3333 |
| jl2012 | 3.3333 |
| jayeeyee | 3.3333 |
| erik m. | 3.3333 |
| vegito | 3.3333 |
| co0ler | 3.3333 |
| veneg | 3.3333 |
| star citizen | 3.3333 |
| Hagane | 3.3333 |
| Freedom Force | 3.3333 |
| Star_Bucks | 3.3333 |
| flymnb | 3.3333 |
| smartash | 3.3333 |
| jackmoon | 3.3333 |
| Brzina | 3.3333 |
| Revenant 02 | 3.3333 |
| jamesburrell2 | 3.3333 |
| Linleyi | 3.3333 |
| ozma03 | 3.3333 |
| pasecka | 3.3333 |
| avatar_gr | 3.3333 |
| wheresthecurve | 3.3333 |
| cryptolous | 3.3333 |
| zcroc1 | 3.3333 |
| TheBrute | 3.3000 |
| Annon001 | 3.2857 |
| nanze | 3.2500 |
| explorder | 3.2130 |
| theXcode | 3.1667 |
| J. Becker | 3.1667 |
| Clocktick | 3.1429 |
| growarijo | 3.0909 |
| bitpop | 3.0000 |
| randzzz | 3.0000 |
| yabtcl | 3.0000 |
| deadsea33 | 3.0000 |
| walletrecoveryservices | 3.0000 |
| w0lverine | 3.0000 |
| vindyne8 | 3.0000 |
| Videodrome | 3.0000 |
| HakanYAZICI | 3.0000 |
| MrChicken1987 | 3.0000 |
| poopbread | 3.0000 |
| vezt | 3.0000 |
| hodlercoasterguy | 3.0000 |
| asiat123098 | 3.0000 |
| shroomDance | 3.0000 |
| idrisi33 | 3.0000 |
| KingBT | 3.0000 |
| darecky | 3.0000 |
| Triple_X | 3.0000 |
| Justin-Checqit | 3.0000 |
| MrGGates | 3.0000 |
| m0rph3us7 | 3.0000 |
| chain_architect | 3.0000 |
| techtipspt | 3.0000 |
| MtGotts | 3.0000 |
| TheCryptoguyX | 3.0000 |
| 0Alvaren0 | 3.0000 |
| yla1974 | 2.9459 |
| vanessa81 | 2.9412 |
| HCLivess | 2.9048 |
| jackielove4u | 2.8889 |
| kaar | 2.8750 |
| Craige288 | 2.8571 |
| Mysticus | 2.8333 |
| Nomad88 | 2.8095 |
| mnemonicsoup | 2.8000 |
| BitPanda.com | 2.7778 |
| wnj4 | 2.7778 |
| kaptkrunch | 2.7778 |
| cryptodevil | 2.7500 |
| AlexSimion | 2.7500 |
| tongokongo | 2.7500 |
| crypflash | 2.7500 |
| Lutpin | 2.7391 |
| maccaspacca | 2.6667 |
| kupido14 | 2.6667 |
| Vitacplus | 2.6667 |
| NoSkyLimit | 2.6667 |
| DecentralizeEconomics | 2.6429 |
| stoffu | 2.6000 |
| cinnamon_carter | 2.5714 |
| LZ | 2.5000 |
| georgewilliams | 2.5000 |
| Enkel | 2.5000 |
| Xandrah | 2.5000 |
| xwtfx | 2.5000 |
| BetcoinCasino | 2.5000 |
| Alondre | 2.5000 |
| proletariat | 2.5000 |
| IngerDev | 2.5000 |
| fortress | 2.5000 |
| The Legendary | 2.5000 |
| yoseff | 2.5000 |
| qrhyxelle | 2.5000 |
| Obi-Wan Coinob1 | 2.5000 |
| XMR2020 | 2.5000 |
| Fredista | 2.5000 |
| joejoemister | 2.5000 |
| BitCunha | 2.5000 |
| PandapoolNL | 2.5000 |
| F0ME | 2.5000 |
| B!tco!n$ | 2.5000 |
| Bitlinguist | 2.5000 |
| rampantparanoia | 2.4615 |
| coinminter22 | 2.4444 |
| exus | 2.4390 |
| lillo | 2.4000 |
| Joe-Niner | 2.3684 |
| Tranz | 2.3636 |
| umine | 2.3571 |
| Irchus | 2.3529 |
| sickpig | 2.3333 |
| blissz | 2.3333 |
| Jacky_Chan | 2.2727 |
| jochemin | 2.2500 |
| grtthegreat | 2.2500 |
| dietmarfritz59 | 2.2500 |
| seethernac | 2.2500 |
+------------------------+----------+

Code:

+------------------------+---------+
| User | MPEP |
+------------------------+---------+
| roll on | 19.0000 |
| nonnakip | 3.0000 |
| Yaremi | 3.0000 |
| gmaxwell | 2.6364 |
| vfrcbv911 | 2.5000 |
| AStephen2011 | 2.0000 |
| dacoinminster | 2.0000 |
| Sergio_Demian_Lerner | 2.0000 |
| smoothie | 2.0000 |
| Sunderland | 2.0000 |
| BiPolarBob | 2.0000 |
| negeroy | 2.0000 |
| koinsever | 2.0000 |
| sherlock_h | 2.0000 |
| SA Bitcoin Brothers | 2.0000 |
| Aymaro | 2.0000 |
| hula hula | 2.0000 |
| KingBT | 2.0000 |
| Kumbopulus | 2.0000 |
| Tunjevina | 2.0000 |
| Triple_X | 2.0000 |
| Camille_ | 2.0000 |
| dogie | 1.8000 |
| erik m. | 1.6667 |
| Freedom Force | 1.6667 |
| embii | 1.5000 |
| Nathan Graves | 1.5000 |
| secretservice | 1.5000 |
| tam31 | 1.5000 |
| God Fist | 1.5000 |
| haltingprobability | 1.5000 |
| Star_Bucks | 1.4667 |
| vegito | 1.3333 |
| Hagane | 1.3333 |
| kupido14 | 1.3333 |
| Linleyi | 1.3333 |
| kaspersky15 | 1.3333 |
| idrisi33 | 1.3333 |
| cryptodevil | 1.2500 |
| fortress | 1.2500 |
| John (John K.) | 1.2000 |
| pitipawn | 1.1667 |
| jimbobway | 1.0000 |
| Dervish | 1.0000 |
| Drasek | 1.0000 |
| danuker | 1.0000 |
| Stemby | 1.0000 |
| 2GOOD | 1.0000 |
| tfeagle | 1.0000 |
| ziomik | 1.0000 |
| promankirov | 1.0000 |
| notme | 1.0000 |
| ElectricMucus | 1.0000 |
| randzzz | 1.0000 |
| Xian01 | 1.0000 |
| bushstar | 1.0000 |
| DoktorKopf | 1.0000 |
| DanielBTC | 1.0000 |
| thefiniteidea | 1.0000 |
| obit33 | 1.0000 |
| hephaist0s | 1.0000 |
| QuiveringGibbage | 1.0000 |
| No_2 | 1.0000 |
| Dimitry | 1.0000 |
| yabtcl | 1.0000 |
| lavajumper | 1.0000 |
| binaryFate | 1.0000 |
| nov | 1.0000 |
| BitChick | 1.0000 |
| Petr1fied | 1.0000 |
| deadsea33 | 1.0000 |
| boondogger | 1.0000 |
| sp383 | 1.0000 |
| ghibly79 | 1.0000 |
| Fuserleer | 1.0000 |
| walletrecoveryservices | 1.0000 |
| mogrith | 1.0000 |
| tobasco | 1.0000 |
| idoB | 1.0000 |
| Nerull | 1.0000 |
| kuroman | 1.0000 |
| mthcl | 1.0000 |
| hunterwolf | 1.0000 |
| daniobg | 1.0000 |
| jl777 | 1.0000 |
| metamorphin | 1.0000 |
| Thingamajig | 1.0000 |
| Mares | 1.0000 |
| synace | 1.0000 |
| popshot | 1.0000 |
| TrollCoins | 1.0000 |
| Errror | 1.0000 |
| rby | 1.0000 |
| lfloorwalker | 1.0000 |
| dihydrogenmonoxide | 1.0000 |
| BigWait | 1.0000 |
| daschmidty | 1.0000 |
| Cebuu | 1.0000 |
| rock_collector | 1.0000 |
| Nefritox | 1.0000 |
| svetoch | 1.0000 |
| cryptobullion.io | 1.0000 |
| 2tejszy | 1.0000 |
| miguelmorales85 | 1.0000 |
| dive | 1.0000 |
| Mr_SeLeNiO | 1.0000 |
| ParkByte | 1.0000 |
| xxxxxzzzzz | 1.0000 |
| avlarin56 | 1.0000 |
| bit22gen | 1.0000 |
| Sniper44 | 1.0000 |
| grnqrtr | 1.0000 |
| Unread | 1.0000 |
| 86- | 1.0000 |
| Phi-Coin | 1.0000 |
| Videodrome | 1.0000 |
| Alex4J | 1.0000 |
| obusco | 1.0000 |
| barisbilgili | 1.0000 |
| Neo Baudrillard | 1.0000 |
| drakonka | 1.0000 |
| RedsC | 1.0000 |
| Pesmand | 1.0000 |
| MikkiRefur | 1.0000 |
| PokemonGoArena | 1.0000 |
| TheBobyHunter | 1.0000 |
| luckyluckybear | 1.0000 |
| coinsmanager | 1.0000 |
| co0ler | 1.0000 |
| efeaydin | 1.0000 |
| star citizen | 1.0000 |
| alex_mercer | 1.0000 |
| ranacond | 1.0000 |
| KualaBit | 1.0000 |
| HakanYAZICI | 1.0000 |
| dashxplorer | 1.0000 |
| liubeibei520 | 1.0000 |
| theguy217 | 1.0000 |
| Hypocritus | 1.0000 |
| charlescoin | 1.0000 |
| packetsmurf | 1.0000 |
| bruboi | 1.0000 |
| mararn1618 | 1.0000 |
| berkatmendrofa | 1.0000 |
| Camineet | 1.0000 |
| squishthedish | 1.0000 |
| Hernandezz | 1.0000 |
| silverbu11et | 1.0000 |
| eBunny6 | 1.0000 |
| BaBaGucci | 1.0000 |
| smcalister91 | 1.0000 |
| MrChicken1987 | 1.0000 |
| treather | 1.0000 |
| robinson79 | 1.0000 |
| lorddefenser | 1.0000 |
| SashaK | 1.0000 |
| flymnb | 1.0000 |
| smartash | 1.0000 |
| Simon123 | 1.0000 |
| ilovestroberi | 1.0000 |
| archer1969 | 1.0000 |
| Dropper | 1.0000 |
| frenchBulle | 1.0000 |
| Merderion | 1.0000 |
| stoicphoenix | 1.0000 |
| Mendrofa | 1.0000 |
| Bumidinasty | 1.0000 |
| kukurikapu | 1.0000 |
| LindaQ | 1.0000 |
| jomidasma | 1.0000 |
| appleffi | 1.0000 |
| ragnar0k | 1.0000 |
| kbdwarrior | 1.0000 |
| vezt | 1.0000 |
| posmonkey | 1.0000 |
| Str1x | 1.0000 |
| traktorbang | 1.0000 |
| DeeMiner | 1.0000 |
| e360 | 1.0000 |
| berkatjunior | 1.0000 |
| AlexPechkin | 1.0000 |
| bennypagulayan | 1.0000 |
| Kimyo | 1.0000 |
| Simonetta | 1.0000 |
| Hunter#12 | 1.0000 |
| icoinspector | 1.0000 |
| VazLorde | 1.0000 |
| renriyon | 1.0000 |
| Krypto Krecik | 1.0000 |
| OliverChassa | 1.0000 |
| Dextord | 1.0000 |
| getzer | 1.0000 |
| TooSmartForBitcoin | 1.0000 |
| crypto_flair | 1.0000 |
| declan- | 1.0000 |
| homi4oka | 1.0000 |
| ICAMerlin | 1.0000 |
| dogrutamamyaparimusta | 1.0000 |
| LotusPetal | 1.0000 |
| ennafa | 1.0000 |
| vadiara50 | 1.0000 |
| Derloda | 1.0000 |
| Salranax | 1.0000 |
| walhalla007 | 1.0000 |
| Pochakytek | 1.0000 |
| Miningfarmer | 1.0000 |
| arnew1 | 1.0000 |
| monote | 1.0000 |
| Bitshare Hashaway | 1.0000 |
| seanreit | 1.0000 |
| diaahussein | 1.0000 |
| Marteloto | 1.0000 |
| hodlercoasterguy | 1.0000 |
| vvoin | 1.0000 |
| Bapt07 | 1.0000 |
| asiat123098 | 1.0000 |
| Rokhim | 1.0000 |
| davidrus123 | 1.0000 |
| batuh007 | 1.0000 |
| MaxKordek | 1.0000 |
| spiffy_tycoon | 1.0000 |
| CryptoTesla | 1.0000 |
| totwotoo2 | 1.0000 |
| Mega2017 | 1.0000 |
| merszxc | 1.0000 |
| hassan.shakeel.rajpoot | 1.0000 |
| Conquermountains | 1.0000 |
| tizzle81 | 1.0000 |
| ANNBumping_needed | 1.0000 |
| CryptozKeeper | 1.0000 |
| Georgiano | 1.0000 |
| BitcoinAtom | 1.0000 |
| polza | 1.0000 |
| syavca | 1.0000 |
| CanadianMiner | 1.0000 |
| publicjud1 | 1.0000 |
| mysonkovbereslava | 1.0000 |
| Cointach | 1.0000 |
| mahirovic | 1.0000 |
| darecky | 1.0000 |
| ThorbenS | 1.0000 |
| kreeoz | 1.0000 |
| everton-1888 | 1.0000 |
| nasuhdede | 1.0000 |
| orangepeel | 1.0000 |
| DarkoReborn | 1.0000 |
| coinshido | 1.0000 |
| RonanLTC58 | 1.0000 |
| Cryptostrong | 1.0000 |
| forward777 | 1.0000 |
| cryptosk8boreder | 1.0000 |
| gexaha | 1.0000 |
| alan296 | 1.0000 |
| chessentric | 1.0000 |
| Tobi97l | 1.0000 |
| Milan_P | 1.0000 |
| Scwimer | 1.0000 |
| mswjec | 1.0000 |
| Wys-addict | 1.0000 |
| MrGGates | 1.0000 |
| DavidLutz | 1.0000 |
| Cryptobitminer | 1.0000 |
| aburnie | 1.0000 |
| apolonn | 1.0000 |
| Arpad977 | 1.0000 |
| Atalol | 1.0000 |
| m0rph3us7 | 1.0000 |
| flawlicious | 1.0000 |
| kovaaz | 1.0000 |
| k453345 | 1.0000 |
| macioch | 1.0000 |
| nicholashscott | 1.0000 |
| MetropolisHastings12 | 1.0000 |
| rrgarcia555 | 1.0000 |
| Red Right Hand | 1.0000 |
| chiquinho | 1.0000 |
| abihey269 | 1.0000 |
| urBTCisMine | 1.0000 |
| SMFSMF5555 | 1.0000 |
| EtherAndy | 1.0000 |
| sky_rocker | 1.0000 |
| AAIX | 1.0000 |
| abh1manyu | 1.0000 |
| FlyingAce | 1.0000 |
| I.Meet.Ya | 1.0000 |
| mandymiller | 1.0000 |
| EgonSpengler | 1.0000 |
| MrFoxDeveloper02 | 1.0000 |
| rickybobby856 | 1.0000 |
| Tankie | 1.0000 |
| ChampionGold | 1.0000 |
| RedSlayerX | 1.0000 |
| Two-faced | 1.0000 |
| Gordon___123 | 1.0000 |
| bbritva | 1.0000 |
| prunsebas | 1.0000 |
| OutSmartm | 1.0000 |
| toxicpyjamas | 1.0000 |
| bitrails | 1.0000 |
| tenderwall | 1.0000 |
+------------------------+---------+

A major statistical difficulty which I remembered when gathering these is that a lot of people receive merit for pre-merit posts. (Though people who made zero post-merit posts were excluded in the above stats.)

Gathering these stats is slow. It could be tracked live per user, but I'd have to add a lot of caching at various points. I'm probably not going to do it.

The weekly tracking is an interesting idea.

DdmrDdmr

legendary

Activity: 2310

Merit: 10758

There are lies, damned lies and statistics. MTwain

Quote from: d_eddie on April 23, 2018, 11:10:12 PM

<...>

The way I see it, I think your EMEP proposal would be a better measure than EMEA, since it covers all post and not just a pondered fortnight count on them. In either case, as you say, only post posted since merit system kick-off should be considered for this indicator, avoiding the effect theymos mentions when pondering all the post history.

Another possible personal indicator would be something in the line of MPEP:

Code:

100 * (Nº of distinct Merited Posts / Nº of Posts)

The MPEP indicator should again only consider post merit kick-off posts.

The two are in fact complementary. I could have made 1 good post out of 50 and receive 50 sMerits for it, or I could have posted 50 posts and received 1 sMerit for each post. In either case, My Merit Counter would have been incremented by 50.

In the first case I would have EMEP: 50/50 =1 and MPEP: 100 * (1/50) =2%
In the second case I would have EMEP: 50/50 =1 and MPEP: 100 *50/50 =100%

EMEP stated that both cases have the same ratio, but MPEP gives as insights as to how the earned merits are spread out over all posts belonging to the user. The latter is a better poster overall in theory.

Something similar ratios could be though out from the awarding point of view (how much do I award?, Do I award evenly or not (by looking at the standard deviation for example vs mean).

The thing is, figuring out what to do with these indicators and what operational use they have. For example, should they be placed on the user profile and could be a way to create self-challenge for improvement of the values of the indicators?
They could also be placed on the user information area by the posts, so everyone could see them, but could be too easily taken as indicators for awarding/ingoring the user’s posts (this could be both good and bad, depending where our indicator values lie).
Or they could conform a general stat to the forum.

I’m not sure if the OPs intention in this post is limited to personal indicators, or global stats too. Some simple global indicators in addition to the currently shown could be in the line of:

These indicators help monitor sMerit overall flow and are both beneficial and potentially controversial. The interesting new columns that I haven’t seen around before are nFromNew (number of new users that award sMerit and have not done it on previous weeks) and nToNew (number of users that receive sMerit for the first time). Positive news here is that roughly 30++% of awarded users are "new", that is, they receive their first sMerit, so it is not all going to consolidated users. Quantity is small though.

Note: Week is natural monday to sunday (the last week (16th) is therefore partial since sMerit.txt file goes up to early friday morning.

d_eddie

legendary

Activity: 2492

Merit: 2939

Quote from: theymos on April 23, 2018, 09:07:40 PM

I tried two or three different metrics for things like "emep", but they all had poor results, mainly because so many posts were made pre-merit and there's so much difference between users on the various input variables. If people have ideas for stats in this vein, give me an exact formula with preferably only a few input variables. I might at least post some global stats, though maintaining an up-to-date stat for each user might be too slow.

For the merit rate, I was thinking of something like

Code:

(1) EMEP = merit_earned / posts_since_merit_system

where merit_earned = merit - merit_airdropped_for_rank,
trying to capture how many rewards were earned for posts made after merit was introduced.

Alternatively,

Code:

(2) EMEA = merit_earned / activity_since_merit_system

which might have some advantage I can't see.

Both metrics would indirectly provide info as to the posters' rank at the time of merit introduction, or to their activity since then. If this is undesired, larger buckets could be provided for the merit rate:

Code:

(3)
# MP = EMEP, EMEA, or similar quantity.
if (MP >= 1.0) return 'A'
if (MP > 0.5) return 'B'
if (MP > 0.3) return 'C'
...
if (all else fails) return 'Z'

A useful statistic can be computed without reference to the actual number of posts - e.g., something like

Code:

(4) latest_merit_increment/latest_activity_increment

where both increments are within the same 14-day period.

If the metric needs to smoothed out against volatility, it could be implemented with some time quantization, , possibly a time moving average (exp decay?).

This is off the top of my head. I haven't given the matter serious thought, honestly. If anything sensible pops up, I'll add to this thread. I was hoping to stir some rational discussion, so I'm happy the mighty were indeed listening. Thank you!

(@InvoKing: thank you too Wink

)

theymos

administrator

Activity: 5166

Merit: 12850

I tried two or three different metrics for things like "emep", but they all had poor results, mainly because so many posts were made pre-merit and there's so much difference between users on the various input variables. If people have ideas for stats in this vein, give me an exact formula with preferably only a few input variables. I might at least post some global stats, though maintaining an up-to-date stat for each user might be too slow.

InvoKing

legendary

Activity: 2142

Merit: 1065

✋(▀Ĺ̯ ▀-͠ )

Quote from: actmyname on April 23, 2018, 08:39:21 PM

Go to your profile information page. Turn on post count.

Now you have merit and the number of posts. Divide.

What's the point of adding this in? It's not a good quantifier of post quality. Though unfortunate, a user may not receive as much merit as they deserve. Or they may receive more merit than they deserve (e.g. peloso meriting me)

Dividing all posts / merit could be useful for new users that joined after merit implementation, however the OP means from what i understood

Quote

Maybe by "Eligible post" I meant "Activity since the Merit System" rather than "Actual posts since the Merit System"

https://bitcointalksearch.org/topic/m.35430725

Kind of neutral this time to the propositions, however, i still recommend a like button..

actmyname

copper member

Activity: 2562

Merit: 2504

Spear the bees

Go to your profile information page. Turn on post count.

Now you have merit and the number of posts. Divide.

What's the point of adding this in? It's not a good quantifier of post quality. Though unfortunate, a user may not receive as much merit as they deserve. Or they may receive more merit than they deserve (e.g. peloso meriting me)

InvoKing

legendary

Activity: 2142

Merit: 1065

✋(▀Ĺ̯ ▀-͠ )

Quote from: d_eddie on April 23, 2018, 07:58:47 PM

If I could get heard by the mighty Theymos, I would very much like to ask if we could get more statistics. We need something like "Imagination", "Magic Dust" or "Emep", which might stand for "Earned Merit per Eligible Post (ratio)".

The first has been implemented, but we saw it didn't work out. Could we have the other two? Or just the last, maybe? It actually could give us a useful view of someone's history here.

Or some other number/bucket system like that, perhaps. I'm sure several tweaks could be twoken to fuzzy it up a bit if deemed appropriate.

A little bit confused about the relation between these three. Imagination was used in April 1, and I don't think enabling it will be that useful.
For Emep, how could you tell if a post deserves to be merited or not? If there is a like button and crossing likes vs merit then it might be possible, otherwise, I don't see how.
Sr+ Wink

d_eddie

legendary

Activity: 2492

Merit: 2939

If I could get heard by the mighty Theymos, I would very much like to ask if we could get more statistics. We need something like "Imagination", "Magic Dust" or "Emep", which might stand for "Earned Merit per Eligible Post (ratio)".

The first has been implemented, but we saw it didn't work out. Could we have the other two? Or just the last, maybe? It actually could give us a useful view of someone's history here.

Or some other number/bucket system like that, perhaps. I'm sure several tweaks could be twoken to fuzzy it up a bit if deemed appropriate.

Topic: A useful user statistic to show - Magic Dust or Emep? (Read 302 times)