This article explains how to create a force directed network diagram using Sisense. This is helpful for showing hierarchies or relationship within your data.
The following steps will walk through the process of adding the new chart type and creating a sample funnel chart.
Step 1 - Add the Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server.
Step 2 - Create the Chart
On your dashboard, create a new widget and select Force Directed as the type. In order to work with this visualization, you need to specify at leas a Node ID and Linked Node ID. This is basically how the relationship is defined within the data. If you think about this in terms of an employee hierarchy, the Node ID field would usually be an employee ID and the Linked Node ID would be the employee's manager ID.
There are also several optional fields you can add in
- Node Labels - The value label for each node (such as the employee's name)
- Color - This field determines how to color each node. You can use a dimension here (such as department name) or a metric (such as Sales per Employee). When using an Icon to display each node, this field is ignored
- Node Size - This field determines the size of each node. The higher the value, the larger the node is displayed. When not specified, all nodes are displayed with the same size
- Node Icon URL - Use this field to specify an image to show for each node. This should be a URL to where the images are hosted. If a node is missing an icon url, it will show a circle instead. If this field is left blank, each node will show up as a circle.
Step 3 - Format the chart
This visualization has several formatting options, see below for a description of each.
- Node Circle Size - A slider control that allows the designer to determine the range used for sizing each node
- Size Scale Method - Determines which scaling algorithm to use for determining the size of each node
- Selectable as Filters - Controls whether or not each node can set a dashboard filter when clicked on
- Value Labels - Controls whether or not to display labels for each node, and where to place the label
- Zoom from Mouse Scroll - When enabled, a user can adjust the size of the nodes by using their mouse scroll wheel
- Animation - Determines whether or not the chart loads with animation
- Gravity - A slider control for adjusting the gravity of the force layout
- Friction - A slider control for adjusting the friction of the force layout
- Charge - A slider control for adjusting the charge of the force layout
- This plugin was based of a D3 Force Directed visualization. For more information on D3 in general, please see this link. For some generic examples of working with D3, please see this link and this link.
- The bottom 3 sliders in the Design Panel control variables for gravity, friction, & charge. These are D3 specific variables that work together to determine how the chart calculates a layout. For more information on these variables please see the D3 Documentation or this explanation.
- See the attached files for the plugin and also a sample Elasticube & Dashboard