Skip to Content

Chart types

Chart types and the data they need

Every chart type in the picker, what each one needs, and where to set it up.

Each tile in the Chart type picker needs a certain shape of data. Find your chart below, then open its setup page.

Chart type picker with the recommended Bar tile highlighted
The Chart type picker. The line at the top says what this result has.

In the metric builder you add fields to Dimensions and Measures. Databrain puts them into the chart in that order. For most charts, the first dimension is the x axis and each measure is a series.

KPI cards

TileWhat it needsSetup page
Single Value1 column. A measure, or else the first dimension. Shows the first row.Single Value
Gauge1 measureGauge, Progress Bar and Linear Gauge
Linear Gauge1 measureGauge, Progress Bar and Linear Gauge
Progress Bar1 measure. A second and third measure set the range.Gauge, Progress Bar and Linear Gauge

Tables

TileWhat it needsSetup page
TableAny columnsTable and Horizontal Stack Table
Trend AnalyzerAny columnsTrend Analyzer
Pivot Table1 or more dimensions and 1 or more measures, groupedPivot Table
Horizontal Stack Table1 or more dimensions and 1 or more measuresTable and Horizontal Stack Table

Line, bar and area

TileWhat it needsSetup page
Line, Step, Bar, Horizontal Bar, Area1 dimension (x axis) and 1 or more measuresLine, bar and area charts
Bar Stack, Horizontal Bar Stack, Stacked Area1 dimension, 1 or more measures, and a second measure or second dimension to stack byLine, bar and area charts
Time SeriesA date or time dimension and 1 or more measuresTime Series
Hybrid Bar1 dimension and 2 or more measures, groupedHybrid Bar
Gantt4 dimensions in this order: lane, task, start, end, groupedGantt

Combo

TileWhat it needsSetup page
Combo (Multi-Scales), Horizontal Combo (Multi-Scales), Combo (Single-Scale)1 dimension and 2 or more measuresCombo charts
Horizontal Combo (Single-Scale)1 or more measuresHorizontal Combo (Single-Scale)

Pie

TileWhat it needsSetup page
Pie, Doughnut, Rose1 dimension and exactly 1 measurePie, Doughnut and Rose

Distribution

TileWhat it needsSetup page
Histogram1 dimension that holds buckets from your SQL, and exactly 1 measureHistogram
BoxPlot5 measures in this order: min, q1, median, q3, maxBoxPlot
Scatter1 dimension and 2 or more measuresScatter, Bubble and Radar
Radar1 dimension and 3 or more measuresScatter, Bubble and Radar
Bubble2 dimensions (x, y) and 1 measure (size)Scatter, Bubble and Radar

Funnel and flow

TileWhat it needsSetup page
Funnel, Waterfall1 dimension and exactly 1 measureFunnel, Sankey and Waterfall
Sankey2 dimensions (source, target) and 1 measure (value)Funnel, Sankey and Waterfall
Network2 dimensions (source, target) and 1 measure (value)Network

Hierarchy and maps

TileWhat it needsSetup page
Tree map1 or more dimensions and 1 or more measures, groupedTree map
Indian States, USA States, USA States (with bar), World map1 dimension that names a place on the map, and exactly 1 measure, groupedMaps
USA States (with Scatter)As above, plus columns named longitude and latitudeMaps

Custom

Your company’s published custom charts show in the Custom group. Each one names its own data slots. Build a custom chart

“Grouped” means the metric has a measure with an aggregate and at least one dimension. Charts marked grouped do not show until the metric is grouped.

Next: pick a chart type.