Graph from table macro - Cloud
Removal notice
Please note that the URL user and URL user password macro parameters were removed (see Deprecation notice: URL user and URL user password parameters). We recommend using profiles to access external data.
Description
Converts tables found in the rendered body of the macro into a Graphviz graph. Each row found in a table is converted to a node relationship. The Flowchart macro is used for the rendering, so it must be enabled and working correctly. This macro simplifies use of the Graphviz support by eliminating or significantly reducing the need to know the dot language. Advanced users will still need to consult the Graphviz documentation for the multitude of attributes and settings that are possible.
The columns in the table are interpreted as follows:
Node with label equal to the column. The source of a relationship. This is the only required column.
Node with label equal to the column. The target of a relationship.
Relationship attributes.
Source node attributes.
Target node attributes.
First cluster number. A cluster is a subgraph that contains the source and target nodes for this row.
First cluster attributes.
Second cluster number. The second cluster is a subgraph that contains the first cluster.
Second cluster attributes.
Attributes are defined by Graphviz for nodes, relationships, and subgraphs (clusters). They are specified as comma separated list. Attribute values containing blanks must be surrounded by double quotes. Some commonly used attributes are:
label - text to display
style - examples: filled, bold, dotted, dashed, invis (for invisible)
fillcolor - node fill color
fontname - standard font name (enclosed in double quotes if contains a blank)
fontsize - standard font size
fontcolor - color usually specified as a color name like blue, grey, lightyellow
shape - examples: rect, box, circle, ellise, triangle, polygon (together with sides attibutes), diamond, ...
sides - number of sides for a polygon shape
peripheries - number of node boundaries
Graphviz resources
Parameters
Macro specific parameters
Macro Editor Label | Default | Description | Macro Parameter |
|---|---|---|---|
Direction of graph (rankdir) | LR | Sets the graphviz rankdir parameter
| direction |
Node parameters |
| Sets the graphviz node parameter. The default node attributes are taken from the default Flowchart macro behavior. By specifying the node parameter, you can override these defaults or add additional default attributes. See the Graphviz Documentation for information on attributes and settings. | node |
Edge parameters |
| Sets the graphviz edge parameter. The default edge attributes are taken from the default Flowchart macro behavior. By specifying the edge parameter, you can override these defaults or add additional default attributes. See the Graphviz Documentation for information on attributes and settings. | edge |
Replace variables |
| A comma separated list of key:value pairs that is used to convert column values to attributes. If a column value for an attribute column matches one of the keys, the associated value replaces the column value. This makes it easy to associate attributes to column data. If more than one attribute needs to be specified for a key, enclose the value in a single quote so that the comma gets treated as a attribute separator. | replace |
Table ids or numbers to include | all | Comma separated list of table ids and/or table numbers contained within the body of the macro that is used as the data for the graph. | tables |
Column numbers to include |
| Allows selection of the columns of the table that is used for the graph. It must be a comma separated list of 1 or more positive integers in any order. The default value of blank represents columns=1,2,3,4,5,6,7,8,9. If the table does not contain the column indicated, it is ignored. For example, if columns=3,13 then column 3 is used for the source node and column 13 is used for the target node of the relationship. All other columns are ignored. | columns |
Other Parameters
All other parameters are passed through to Graphviz for setting any global Graphviz parameter. Some common examples are:
ranksep - Separation in inches between nodes.
bgcolor - Background color.
size - Size specified as width, height in inches. Example: size="3,5".
Usage
Simple
{graph-from-table}
| A | B |
| A | C |
{graph-from-table}
Relationship and node attributes
Note that headings are ignored
{graph-from-table}
|| heading 1 ignored || heading 2 ignored ||
| A node | B node | label="relationship 1", style=dashed | style=normal | fillcolor=lightblue |
| A node | C node |
| A node | D node | style=invis |
{graph-from-table}
Multiple tables and using parameters
{graph-from-table:node=fillcolor=lightblue,fontsize=20|edge=style=bold,color=red| replace=key1:'style=dashed, color=blue', key2:style=invis|ranksep=2.0}
| A node | B node | | shape=polygon,sides=8,peripheries=3 | |
| A node | B node | | style=dashed |
| A node | C node |
| A node | D node | key2 |
Here is a second table
| E | F | key1 |
| F | G | key1 |
{graph-from-table}
Subgraphs - clusters
{graph-from-table:direction=LR|ranksep=1.5|node=fillcolor=lightblue,fontsize=20| edge=style=bold,color=red|replace=key1:style=dashed}
| A node | B node | label="r1" | | | 100 | key1 |
| F | G | key1 | | | 100 | label="cluster 100" |
| X | Y | key1 | | | 200 | label="cluster 200" | 2000 | label="cluster 2000" |
{graph-from-table}
Need support? Create a request with our support team.
