Number of earned Merit during the last 120 days (counted automatically)

1miau

legendary

Activity: 2226

Merit: 6947

Currently not much available - see my websitelink

Quote from: DarkStar_ on March 27, 2019, 09:57:39 PM

The site doesn't seem to include the sum of all merits in that 120 day period, which is what 1miau is asking for I believe.

Exactly, someone asked it for the new signature campaigns of Hhampuz. xD

Quote from: Vod on March 27, 2019, 11:04:38 PM

120 days ago would be about this:
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=11/27/18&end=&min=&max=

I now show number of records on the bottom
still working on the summation.

Thanks, looks great and if the total received Merit is implemented that would be a fast method for everyone to look it up.

Quote from: DdmrDdmr on March 28, 2019, 01:00:15 AM

The Merit Dashboard does that. Simply go to the "Received Merit" tab, and adjust the date range slider to the date interval required (i.e. between date x and date y), be it 120 days or other. By default it shows all history. Then enter the user name or user Id on the boxes on the right side of the screen.

I just tried it, works very well

Quote from: LoyceV on March 28, 2019, 02:32:11 AM

I can make it, but does it have to be 100% accurate?

Well, there are already a few variants posted above but it's always a good idea to have multiples ones. If you have time and want to go for some cycled Merits, why not. Tongue

Quote from: LoyceV on March 28, 2019, 02:32:11 AM

A campaign manager could even request candidates to post it. Note that I also provide BBCode for the full Merit history on http://loyce.club/Merit/history/2143453.html.

+1
Interesting how that would work out. The campaign manager posts a link and description how to do it: http://loyce.club/Merit/history/[your user-ID].html
And set is as requirement to join. Just a suggestion.
Maybe you can set it as requirement for your next campaign to select participants. Wink

Thx for your answers everyone!

tbct_mt2

hero member

Activity: 2366

Merit: 838

I think I made a summary from all available solutions raised by some users, there:
Tools for managers to check quality of posts (both merited & unmerited posts)
Feel free to leave your comment if you think I should improve the topic's contents, please.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Using your code, then this is mine, that looks like a random walk.
Shocked

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: 1miau on March 27, 2019, 08:05:23 PM

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. Wink

I can make it, but does it have to be 100% accurate? A rough overview might be better for the purpose of assessing a signature campaign candidate. This is yours:

Data updated until last Friday's data dump, each column is 5 days, the maximum height is 100 Merit (in 5 days), if a user earned more, the top of the column gets darker.
To post it, insert userID in this code:

Code:

[img alt=Image loading...]http://loyce.club/Merit/history/img/userID_blue.gif[/img]

A campaign manager could even request candidates to post it. Note that I also provide BBCode for the full Merit history on http://loyce.club/Merit/history/2143453.html.

DdmrDdmr

legendary

Activity: 2338

Merit: 10802

There are lies, damned lies and statistics. MTwain

The Merit Dashboard does that. Simply go to the "Received Merit" tab, and adjust the date range slider to the date interval required (i.e. between date x and date y), be it 120 days or other. By default it shows all history. Then enter the user name or user Id on the boxes on the right side of the screen.

You should see (data as of last Friday):
- the total amount of merits earned by the forum member in the timeframe (on the right side of the screen, under the name).
- the amount received per rank in that timeframe.
- a breakdown by month.
- a breakdown by day.
- a summary of the forum names that merited the profile, and amounts, in the timeframe.

To change the username or id, just click on the parameter box, press the "x’ to delete current parameter, and type in a new name.

Note that the software, Tableau Public will timeout after around four minutes of inactivity, so if that happens, the date range may need to be provided again.

You can also see (on the "Rankings" tab) the most merited profiles in a given timeframe and board.

tbct_mt2

hero member

Activity: 2366

Merit: 838

Quote from: Vod on March 27, 2019, 11:04:38 PM

120 days ago would be about this:
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=11/27/18&end=&min=&max=

I now show number of records on the bottom
still working on the summation.

It works fine, but I thought that it might be better if you add Search box, then searcher can type account name and start day to search, rather than directly typing it into the browser.

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: tbct_mt2 on March 27, 2019, 10:45:41 PM

https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=120&end=&min=&max=

120 days ago would be about this:
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=11/27/18&end=&min=&max=

I now show number of records on the bottom
still working on the summation.

tbct_mt2

hero member

Activity: 2366

Merit: 838

Quote from: Vod on March 27, 2019, 09:48:29 PM

https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=

Just put profile name after to= and 120 days ago in start=

Did I search it right, Vod?
Results seems to be wrong, that is not the feature should show.
Please correct me if I made something wrong when searching.
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=120&end=&min=&max=

DarkStar_

legendary

Activity: 2772

Merit: 3284

Quote from: Vod on March 27, 2019, 09:48:29 PM

Quote from: tbct_mt2 on March 27, 2019, 08:52:55 PM

Quote from: 1miau on March 27, 2019, 08:05:23 PM

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. Wink

You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.
He can do it for sure if he want.

Thx.

Already done:
https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=

Just put profile name after to= and 120 days ago in start=

The site doesn't seem to include the sum of all merits in that 120 day period, which is what 1miau is asking for I believe. As a workaround, you can copy the output given by BPIP and it formats nicely in Google Sheets (and I assume Excel):

You can then easily sum the values.

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: tbct_mt2 on March 27, 2019, 08:52:55 PM

Quote from: 1miau on March 27, 2019, 08:05:23 PM

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. Wink

You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.
He can do it for sure if he want.

Thx.

Already done:
https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=

Just put profile name after to= and 120 days ago in start=

r1s2g3

sr. member

Activity: 742

Merit: 395

I am alive but in hibernation.

I guess I can put a custom query in Piggy sql tool but only issue is Piggy database is updated on Friday.(not the real time updates)

Did not checked DdmrDdmr Merit dashboard.

Unfortunately Vod is only displaying data and do not provide any privilege to do Data Analytics on it.

Quote from: 1miau on March 27, 2019, 08:05:23 PM

Does someone know about a tool where it's possible to count the received Merit for the last 120 days automatically? Counting all Merits manually is still possible but not very fast (depending on the number of earned Merit)

The only site I know is this one, but it's limited to a few accounts: https://bitcointalk.org/index.php?action=merit;stats=topusers

Someone asked this today in the German local board.

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. Wink

These are recent merits, may be last 30 days, not 120 days as you thought.

tbct_mt2

hero member

Activity: 2366

Merit: 838

Quote from: 1miau on March 27, 2019, 08:05:23 PM

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. Wink

You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.
He can do it for sure if he want.

1miau

legendary

Activity: 2226

Merit: 6947

Currently not much available - see my websitelink

Does someone know about a tool where it's possible to count the received Merit for the last 120 days automatically? Counting all Merits manually is still possible but not very fast (depending on the number of earned Merit)

The only site I know is this one, but it's limited to a few accounts: https://bitcointalk.org/index.php?action=merit;stats=topusers

Someone asked this today in the German local board.

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. Wink

Topic: Number of earned Merit during the last 120 days (counted automatically) (Read 443 times)