Custom Data Network Visualizer
Instructions on how to set up your own custom data network visualization.
Last updated
Instructions on how to set up your own custom data network visualization.
Last updated
The nodes query defines the nodes in the network.
Parameter | Description |
id | Id for the node. This will be used by the edges to define the relationships. |
title | This is the text that is displayed when hovering on a node. |
label | The label that is shown below the node. |
value | The visual size of the node relative to other nodes. |
mass | The gravitational pull of a node. Unless you really want to customize the visualizer, it is recommended to keep this the same value as the value. |
group | Optionally you can associate a node with a group. |
color | Optional hex code for the color of a node. The node will take the color of the group if a color is not specified for the node. |
description | The description shows up in the top right hand corner when you click a node. |
nodeURL | Page to display when you click the open button next to the description. |
The edges query defines the relationships between the nodes.
Parameter | Description |
id | Id for the edge. |
label | Label that shows up on the edge. |
from | Originating node id. |
to | Target node id. Can be the same as the from node, it will show a loop back into the same node. |
showArrowTo | Set this to True if you want to show the direction of the relationship. |
showArrowFrom | Generally should only be used for bi-directional relationships along with the arrow to. |
Node groups are an optional query you can provide to group your nodes.
Parameter | Description |
sub network | Name for the group |
color | Hex value for the color of the group |
If no start or end date is specified, the data network is just shown as is. If there's a start or end date, the other CQLs need to have a @date parameter and that will be used to render the data network at a point in time.
You can use @date between [Modified] and [Replaced] with a version history query to see data at a point in time. You can also simply use @date > [Created] if it's an additive system.
This CQL should return a date value as 'startDate'.
This CQL should return a date value as 'endDate'.
To use slicers, you need to define the slicers in the [Slicers] column and add the additional attributes to the nodes query.
Attribute is the column name from the nodes query, displayName is what shows up in the visualizer.
All the information above is entered into the [Cinchy].[Networks] table. To access the network, go to
<Cinchy URL>/Cinchy/apps/datanetworkvisualizer?network=<NAME>
Alternatively you can go to My Data Network and then add ?network=<NAME> to the end of it.
It is highly recommended to add a new applet for each custom data network visualizer for ease of access.
For ease of testing, save the following as saved queries and then in the Networks table simply add exec [Domain].[Saved Query Name] as the CQLs.
