Creating Network Graphs

[thefreekick]

I did one on Flourish last week. It’s based on this example that no longer works because Google discontinued their network fusion chart.

Create a Network chart of your forum - data visualization

Thanks to the Data Explorer Plugin and the query that @riking created, we have a great visualization of the interaction in our instance. [image] You can also play with it. It’s easy to do it: 1 - Install Data Explorer plugin 2 - Run the riking query or an modified version of it.

We use a version that only extracts from a specific group

WITH pairs AS ( SELECT p.user_id liked, pa.user_id liker FROM post_actions pa LEFT JOIN posts p ON p.id = pa.post_id WHERE post_act…

It’s showing

• likes between users in both directions
• colours to highlight groups
• thickness of lines to show the number of likes
• bubble size to show the like ratio for each user (posts/likes)

My example has so many data points it’s difficult to read but I was just experimenting with it anyway. Reducing the number of users or the time period etc would make it cleaner.

TFK Network

Screenshot of selected user below: