Title: Number of earned Merit during the last 120 days (counted automatically) Post by: 1miau on March 28, 2019, 01:05:23 AM 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. ;) Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: tbct_mt2 on March 28, 2019, 01:52:55 AM If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. ;) You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.He can do it for sure if he want. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: r1s2g3 on March 28, 2019, 02:00:44 AM 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. 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. ;) These are recent merits, may be last 30 days, not 120 days as you thought. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: Vod on March 28, 2019, 02:48:29 AM If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. ;) 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= Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: DarkStar_ on March 28, 2019, 02:57:39 AM If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. ;) 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): https://i.imgur.com/eQykiio.png You can then easily sum the values. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: tbct_mt2 on March 28, 2019, 03:45:41 AM https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max= Did I search it right, Vod?Just put profile name after to= and 120 days ago in start= 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= Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: Vod on March 28, 2019, 04:04:38 AM 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. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: tbct_mt2 on March 28, 2019, 04:09:49 AM 120 days ago would be about this: 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.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. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: DdmrDdmr on March 28, 2019, 06:00:15 AM The Merit Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary) 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. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: LoyceV on March 28, 2019, 07:32:11 AM If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it. ;) 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:http://loyce.club/Merit/history/img/2143453_blue.gif 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] Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: tranthidung on March 28, 2019, 02:09:12 PM Using your code, then this is mine, that looks like a random walk.
:o http://loyce.club/Merit/history/img/1292764_blue.gif Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: tbct_mt2 on March 28, 2019, 02:57:42 PM 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) (https://bitcointalk.org/index.php?topic=5125595.0) Feel free to leave your comment if you think I should improve the topic's contents, please. Title: Re: Number of earned Merit during the last 120 days (counted automatically) Post by: 1miau on March 28, 2019, 10:55:38 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. xD120 days ago would be about this: Thanks, looks great and if the total received Merit is implemented that would be a fast method for everyone to look it up. 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. The Merit Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary) 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 :) https://i.imgur.com/AiVZxIy.jpg 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. :PA 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 (https://bitcointalk.org/index.php?topic=1777744.0) to select participants. ;) Thx for your answers everyone! |