Sankey diagrams display flows from one state to another, the width of the arrows is proportional to the flow rate of the depicted extensive property. Pulse allows creating a sankey Diagram directly from a database query or Pulse Pivot.

Sankey Diagram Table Format

To convert a table to a sankey Diagram each row is considered a flow from left to right.

  • Assuming string columns named S1,S2,S3 with a numeric column of value V.
  • Each row represents one flow from the top level S1 to the leaf node S3. S1->S2->S3->V
  • The first numeric column reprents the size of the flow between nodes.
  • Sizes are back-propagated to the top level.

The diagram below is an example of a table and it's corresponding image as a sankey diagram.

Sankey Diagram Table Format

In particular notice the bottom row highlighted contains null entries, The row only has an Exchange=CBE=18 entry. This results in the width of the CBE node being expanded but no inflow/outflow.

If you hover over a node, that node will be highlighted.
If you click a node or link, variables will be populated allowing dynamic queries.

Sankey Diagram Hover to show Flow

Pulse is constantly improving. If you would like a feature added to our Sankey Diagram, please raise an issue.

Example Queries:

kdb+ Example Sankey Query:

BabelDB Example Query:

Example Database Query Result

Column Value Collisions

Naively using the values in a column could result in confusion in the case of an overlap. For example in the below table, China occurred as both a trading block and as a country. To ensure the naming is clear, in this case Pulse will automatically prefix the column names where applicable:

Sankey Diagram Hover to show Flow