Full Merit transaction history for any user - with GRAPHS, BANS and BBCode!

[LoyceV]

Nice, that does seem to work perfectly, very impressive Loyce! If it doesn't take that much storage or resources, it makes me wonder why theymos isn't doing that "officially".

Theymos generates the merit history "on the fly", and said the main reason not to keep it forever is because adding pagination is a lot of work.
Without pagination, it will eventually give time-outs, just like some people have a hard time viewing their ignore list, or loading long trust lists (I think that's why the trust page doesn't show the trust summary of other people anymore).

I still need to automate uploading, once done, I'll update the OP and this thread becomes obsolete a link to the real data.

[DdmrDdmr]

<...>

Works nicely, well done. I would suggest editing the OP to reflect this change as it is important to see at the beginning of the thread.

[mdayonliner]

Example: http://loycevsbasement.privatedns.org/Merit/history/459836.html is my full history. Change the userID to any other user that has either received or sent merit. Each user mentioned on the link has a link to his own history.

Fantastic work! It worked correct for me. Consider this as a confirmation. http://loycevsbasement.privatedns.org/Merit/history/1432468.html

PS: I wanted to merit you for the post but then again I thought not to waste one of my merit since you are both a Legendary member and a merit source. By the way, In your mind you can set a merit from me Good work again bud.

[LoyceV]

I'm experimenting with making a graph per user, showing the number of Merit sent and received per week.

[bill gator]

Without pagination, it will eventually give time-outs, just like some people have a hard time viewing their ignore list, or loading long trust lists (I think that's why the trust page doesn't show the trust summary of other people anymore).

You've taught me a new word, had to look up "pagination". After doing a bit of reading I still don't particularly understand exactly what is lacking currently. Does that mean, in this case, that a more modular approach would be required? I'm trying to understand exactly what is causing the time-outs, and exactly what pagination means in this context.

Thanks for another tool on my bookmark list, Loyce. I also don't understand how this thread would become obsolete, if you are still accomplishing the original goal; just accomplishing it more efficiently. Maybe this is just going over my head, but I'd say this is anything but obsolete.

[LoyceV]

You've taught me a new word, had to look up "pagination".

I got it from theymos too

After doing a bit of reading I still don't particularly understand exactly what is lacking currently. Does that mean, in this case, that a more modular approach would be required? I'm trying to understand exactly what is causing the time-outs, and exactly what pagination means in this context.

Pagination is what you see under this page:
Pages: « 1 2 3 [4]  All
Well, I don't think the "All" is pagination, the rest is.

I think the time-outs were caused by loading too much data at once (just guessing here).

I also don't understand how this thread would become obsolete

Good point. My original idea was to have a bot running in this thread, the obsolete means there's no point requesting data anymore, as it's already available.

[Jet Cash]

Is there a way to back up the merit tree to try to detect merit rings?
I'll explain what I meant - A receives 5 sMerits from B, These were generated by awards of 10 sMerits from C, created by 20 sMerits from D, and so on. Of course any awards by merit sources will not have been created by awards. A, B. C, D and others may be the same member if it is part of a loop. I'm not sure if this sequence is trackable, as sMerits are not unique, but just go into a pool.

[LoyceV]

Is there a way to back up the merit tree to try to detect merit rings?

It has too too many variables, so I'll pass on this one.

[Jet Cash]

It has too too many variables, so I'll pass on this one.

That was my feeling as well. I wondered if it was possible to create a cluster diagram based on a single post with high merit.

[LoyceV]

I'm experimenting with making a graph per user, showing the number of Merit sent and received per week.

Preliminary results: this would be satoshi's graph of Received Merit, which I want to publish on http://loycevsbasement.privatedns.org/Merit/history/3.html.



Current settings:
-column width: 10 pixels (5 days)
-"days" start the second the first Merit was transfered, and count exactly 5*3600*24 seconds after that. It has nothing to do with calendar days in any time zone
-column height: 3 pixel per Merit
-maximum of 200 Merit per period, darker color at the top if the bar has been cropped
It still needs something on the axes.

It has space to grow in width, but I think it's too high for the layout. I'm now thinking to make it a maximum of 200 pixels high, with 2 Merit per pixel. That means most users will have a few blue dots at the bottom only.

I need comments

[LoyceV]

This looks better (height limited to 100 Merit per 5 days):

[LoyceV]

I've added graphs to each user's Merit history. These are mine:
Merit sent by LoyceV:

Merit received by LoyceV:

I didn't expect such a large difference between "now" and when Merit was introduced!

Each column width is 5 days (10 pixels). "Days" start the second the first Merit was transfered, and count exactly 5*3600*24 seconds after that. It has nothing to do with calendar days in any time zone
The maximum is 100 Merit per column (2 pixels per Merit). If more than 100 Merit was transfered in a 5 day period, the top of the column gets darker.
It still needs something on the axes.

In a next run, I'll change the background from white to gray. That should make it easier to see the edges of the graph, especially for users with only a few Merit transactions.

[mdayonliner]

~

Mine looks opposite  




Another good work mate. Seems like you are having fun with all these data analysis, graph drawing etc.

PS: May be we need an outside boarder line with legend for better visual. Like below:


If it's something too hard to waste your time then don't bother.

[LoyceV]

Mine looks opposite  

I guess that means you're developing. I like the easy overview it gives.

Another good work mate. Seems like you are having fun with all these data analysis, graph drawing etc.

I got sucked in, and one thing led to another I still haven't completed my TODO, and it already takes several hours to process all data. I didn't need to worry about efficiency before, but it's a lot of data by now.

PS: May be we need a outside boarder line with legend for better visual.

I'm not really into graphics design, but if I have a design, I can easily merge it around my graph.
Horizontal lines look good too!

If you can make the graph look better, please do so and send me the changes to add.

[mdayonliner]

If you can make the graph look better, please do so and send me the changes to add.

I have this admin panel theme. It has all sorts of demo charts including the Bar Chart.

I have both php and html version of the theme. Not sure if that's gonna help you in any way. If it does then I can PM you the zip of theme.

PS: Thanks for all these exclusive work you and other guys are doing for better visualization of merit transactions.

[LoyceV]

I have this admin panel theme. It has all sorts of demo charts including the Bar Chart.

That looks good, but it's too complicated to add. I just want something simple to show on the axes.

PS: Thanks for all these exclusive work you and other guys are doing for better visualization of merit transactions.

Thanks, I like doing it anyway

[LoyceV]

The graphs make it easy to spot abuse. If someone suddenly sends and receives a large amount, such as this user (see reference), it's easy to follow where it came from and where his sMerits are going to.

[tranthidung]

I recommend @LoyceV to use box plots to show the distributions of merits.
The type of plot help readers easier to see outliers.
I also give you link to see how to graph box plots using R-software.
StatMethods to graph BoxPlots using R


Boxplots are very relevant when you want to compare the average and outliers of merit distributions on different boards, ranks, etc.

[LoyceV]

I recommend @LoyceV to use box

That's too much for creating graphs manually (pixel for pixel).

[LoyceV]

Bump for visibility, updated last Friday.