This is a flow diagram from source to target where the width of the arrows is proportional to the flow quantity.
What data do I need for this widget?
The option to create this chart will be disabled unless your query contains at least three columns, one of them with numeric values. Furthermore, to show meaningful content on the chart, you must group your data.
Creating a sankey diagram
Go to Data Search and open the required table.
Perform the required operations to get the data you want to use in the chart.
- Select Additional tools → Charts → Diagrams → Sankey Diagram from the query toolbar.
Click and drag the column headers to the corresponding fields. This diagram requires you to specify three fields:
Required field Data type Source Any type but json Target Any type but json Value float, integer, duration
- The sankey diagram is displayed.
Working with sankey diagrams
Hover over a flow arrow to highlight it and view a tooltip with the variables it connects and the value. Hover over a variable segment on the left or on the right to highlight the set of flow arrows coming to or departing from it as well as the sum of the values.
Click on Stats to show/hide the explanatory information displayed at the top and bottom of the diagram about the links, joins, grouping and nodes.
Click on the button at the top right of the diagram to export the content as a CSV file.
You can recreate the example shown in the picture above with the data from the following query and mapping the fields as follows:
from demo.ecommerce.data group every 5m by method, statusCode, bytesTransferred every 5m
|Required field||Column added|