Hubviz Studio chart types and when to use each one

This page lists what you can build in the Charts area of a project in Hubviz Studio, with an example of each type.

Where to pick the type

• Regular charts: click the + button (Add New Chart/Demonstration/Filter) and choose Chart. You pick the visual type later, in the editor, under Design. You can switch types at any time without losing the series.
• Tables, cohort, filters and statements: show up as their own options in the same + button. The pivot table sits in the Pivot Tables section: click Add New and then New Pivot Table.

How each chart reads the series

Every editor chart uses the same series. A series is a calculation made with cube measures, such as the sum of sales. What changes is how the type uses the periods:

Type	Uses the periods like this
Columns, bars, lines, areas and flow	One point per period, for each series.
Pie and donut	One slice per series, with the value of the last period. With Enable Drilldown, one slice per category.
Funnel	One stage per series, in series order, with the value of the last period.
Gauge	Only the first series, with the value of the last period.
Card	One card per series, with the value of the last period and the change from the one before it.
Table	One row per series and one column per period.

To make the last period represent the whole year, turn on Calculate accumulated series value in the series.

Columns and bars

Column Chart: compares values across periods or categories. It is the easiest type to read.

Stacked Column Chart: shows the total of each period and how much each part contributes.

Horizontal Bars Chart: good for rankings and for categories with long names, such as products or salespeople.

Horizontal Stacked Column Chart: the same as stacked columns, laid out horizontally.

Lines, areas and flow

Line Chart: trend over time, with several series side by side.

Stacked Line Chart: how a total evolves over time, with each series’ share filled in (area).

Flow Chart: shows how each series’ share changes over time, in bands that flow around a central axis.

Pie, donut and funnel

Pie Chart: the share of a few parts in a total, ideally up to five slices.

Donut Chart: the same use as the pie, with room in the middle.

Funnel Chart: stages in sequence, such as leads, opportunities, proposals and sales. Create one series per stage, in funnel order.

Gauge

Gauge: a single value on a dial. The scale goes from -10 to 10, with fixed bands: red up to -3, yellow up to 0, light green up to 7 and green up to 10. Use it for indices on that scale, such as a satisfaction score from -10 to 10. For revenue or targets in currency, prefer a card.

Card and table

Card Chart: one highlighted number (KPI), with an icon and a comparison. See Cards and text.

Table: the series values in rows and columns, with an export button.

Tables and analysis

Type	When to use it
Data Table	List the records of a cube, row by row, like a spreadsheet. See Data table.
Pivot table (Pivot Tables)	Cross fields in rows and columns with totals, such as sales by region and month. See Pivot table.
Cohort	Follow groups that started in the same period, such as customers by signup month and how many are still active.

Filters

Chart Filter creates a list of values (for example, regions or salespeople) that filters the project charts. See How to filter dashboards.

Financial statement

Available on Essential, Professional and Business

Financial Demonstration builds statements line by line, like an income statement, from cube measures. It is available on every plan. See Financial statement.

Mix types in the same chart

Each series can have its own Series Type: column, line or pie. For example: Revenue as columns and Target as a line in the same chart, like Revenue vs. target in the sample project.