Sankey charts

Sankey diagrams illustrate a flow through a process or system. Transactional data is optimal for this type of diagram. For example, financial transactions that take place as money moves through accounts or as a product is process. Many marketing users are familiar with Sankey charts from using Google Analytics to view sales conversions.

When you build a Sankey chart you need to provide at least 2 (two) attributes and one measure. Your x-axis attributes can contain at most 13 values, any more and you cannot view a SanKey chart. ThoughtSpot Sankey charts are read from left to right. The width of the flow represents the measure, the attributes or "steps" appear as solid bars:

Sankey chart example

The Austin Animal Center Outcomes data shows the outcome of processing for different breeds of animal. The measure is the count of total animals. This chart shows the general outcomes for each animal type that entered the system.

When you select a flow, you can see the total number of animals in any flow. For example, you can see that dogs were by far the most likely animal to be returned to their owner, while dogs and cats were both adopted at a high rate.

Limitations

  • Sankey charts do NOT support conditional formatting.

  • Top or bottom keyword results are not accurate.

  • Filter aggregated columns, or columns with aggregated formulas cannot be filtered.

  • Cumulative functions are not supported.

  • Moving functions is not supported.


Was this page helpful?