Full merit transaction history for any user - now with GRAPHS! - page 3.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: tranthidung on July 21, 2018, 02:00:08 AM

What did you mean by stating these words "creating graphs manually (pixel for pixel).

I thought I answered this question already, but I guess I didn't post it.
I literally create the graphs by coloring the pixels one by one with a script.

Quote

Just have a data, using command (a simple one) on statistical softwares, and results will show up fastly.
I think it is very simple procedure, and I can do it very fastly, easily.

If you can recommend any open source software that can do this on Linux, running from the command line, with just some numbers as input, I'd like to try it.

Quote

Unfortunately, I can not retrieve data from the forum (raw data given by @Theymos is not detailed enough for analysis).

What do you need? I've scraped enough data to be able to provide you more details if it's something worth doing.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Quote from: LoyceV on July 11, 2018, 09:35:49 AM

Quote from: tranthidung on July 11, 2018, 08:14:33 AM

I recommend @LoyceV to use box

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

What did you mean by stating these words "creating graphs manually (pixel for pixel).
Just have a data, using command (a simple one) on statistical softwares, and results will show up fastly.
I think it is very simple procedure, and I can do it very fastly, easily.

Unfortunately, I can not retrieve data from the forum (raw data given by @Theymos is not detailed enough for analysis).

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Bump for visibility, updated last Friday.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: tranthidung on July 11, 2018, 08:14:33 AM

I recommend @LoyceV to use box

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

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: mdayonliner on June 29, 2018, 03:11:07 PM

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.

Quote

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

mdayonliner

copper member

Activity: 630

Merit: 420

We are Bitcoin!

Quote from: LoyceV on June 29, 2018, 03:00:40 PM

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: mdayonliner on June 29, 2018, 02:45:31 PM

Mine looks opposite Tongue

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

Quote

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 Tongue

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.

Quote

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

copper member

Activity: 630

Merit: 420

We are Bitcoin!

Quote from: LoyceV on June 29, 2018, 02:15:05 PM

~

Mine looks opposite Tongue

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

Merit received by LoyceV:
Image loading...

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LoyceV on June 26, 2018, 06:07:26 AM

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.

Image loading...

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 Cheesy

Jet Cash

legendary

Activity: 2828

Merit: 2472

https://JetCash.com

Quote from: LoyceV on June 26, 2018, 11:29:22 AM

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Jet Cash on June 26, 2018, 11:21:42 AM

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

legendary

Activity: 2828

Merit: 2472

https://JetCash.com

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: bill gator on June 26, 2018, 10:41:39 AM

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

I got it from theymos too Tongue

Quote

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).

Quote

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.

bill gator

legendary

Activity: 1386

Merit: 1123

Quote from: LoyceV on June 22, 2018, 12:18:37 AM

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

mdayonliner

copper member

Activity: 630

Merit: 420

We are Bitcoin!

Quote from: LoyceV on June 21, 2018, 04:05:28 PM

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 Tongue

Good work again bud.

Topic: Full merit transaction history for any user - now with GRAPHS! - page 3. (Read 26956 times)