# Creating Network Graphs

**URL:** https://meta.discourse.org/t/creating-network-graphs/153311
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [May 30, 2020, 12:27pm UTC](https://meta.discourse.org/t/creating-network-graphs/153311 "2020-05-30T12:27:01Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![thefreekick](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thefreekick/32/43228_2.png) [@thefreekick](https://meta.discourse.org/u/thefreekick)
#### Post date: [May 31, 2020, 8:22am UTC](https://meta.discourse.org/t/creating-network-graphs/153311/3 "2020-05-31T08:22:28Z")

</div>

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](https://meta.discourse.org/t/network-chart-of-your-forum-data-visualization/37426):
>
> Thanks to the [Data Explorer Plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) and the query that @riking created, we have a great visualization of the interaction in our discourse instance. [[image]](http://bit.ly/1O6vDyv) You can also [play with it](http://bit.ly/1O6vDyv). It’s easy to do it: 1 - Install [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin 2 - Run the riking query or an modified version of it.play_button We use a version that only extracts from a specific groupplay_button You could do it another modified version of the SQL query that filter by period 3 - Download the .csv 4 - Create a [Fusion Table](https://www.google.com/fusiontables/data?dsrcid=implicit)5 - Upload the .…

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](https://public.flourish.studio/visualisation/2520157/)**
>
> A Flourish data visualisation by Rocko

Screenshot of selected user below:

 ![image](https://global.discourse-cdn.com/meta/original/3X/7/a/7a4c540c247fad22b5babed12a3ebea0f5900619.jpeg)

---

_[View the full topic](https://meta.discourse.org/t/creating-network-graphs/153311)._