How-to
How to create and edit a chart in Hubviz Studio
Create a chart from cube measures, build the series, pick the type and adjust legend, comparison, drill-down, limit and sorting.
By the end of this guide you will have a chart saved in the project, ready to go on a dashboard. The chart shows series, and each series is a calculation made with cube measures, such as the sum of revenue.
Before you start
Create at least one measure in the cube (see Measures). The measure sets the date field, which becomes the time axis, and can set a grouping field, which becomes the categories for drill-down.
Create the chart
-
In the project side menu, open Charts, click the + button (Add New Chart/Demonstration/Filter) and choose Chart. The editor opens in a new tab.
-
Type the name in Chart Title, above the preview. The tab name changes with it.
-
Under Series, click Add New Series. The Edit Series window opens.
-
Name the series in Name. This is the name shown in the legend.
-
Under Indicator Formula*, click the formula area, open Measures and pick the measure. Use Operators to add, subtract, multiply or divide measures.
-
Choose the Value Formatting and check the result in Formula Preview (Result) and in the Report Preview.
-
Click Save. Repeat steps 3 to 7 for each series.
-
Pick the chart type under Design. The preview changes right away. Adjust the options below the types if needed.
-
Save the tab with Ctrl + S.
While there are unsaved changes, the tab name shows an asterisk (*). If you close the tab before saving, Hubviz Studio warns you that the changes will be lost.
Series list
Each series in the list has three buttons: pencil (edit), trash can (delete) and copy (duplicate). The copy gets the “(copy)” suffix and opens straight for editing.
- Drag a series by the handle on the left to change the order. The order applies to the legend, the default colors and the funnel stages.
- Reset Chart Series deletes every series in the chart.
Series options
They are in the Edit Series window.
| Option | Choices | Default | What it is for |
|---|---|---|---|
| Name | Free text | New Series | Name in the legend, the tooltip and the card. |
| Series Type | Same as chart/report, Column, Line, Pie | Same as chart/report | Mix types in the same chart, such as revenue as columns and target as a line. |
| Value Formatting | Currency, Number, Number without decimal places, Percentage, Hours | Number | How the value shows on the axis, in the tooltip, on labels and on the card. |
| Custom Color | Color picker | Palette color, in order | Fix a series color, such as target always in green. |
| Negative Values Color | Color picker | None | Paint points with negative values in another color, such as losses in red. |
| Plot series on another axis | On or off | Off | Use a second axis when scales are very different, such as revenue in millions and margin as a percentage. |
| Calculate average in chart | On or off | Off | Each point becomes the average of the months up to it, including that month. |
| Calculate accumulated series value | On or off | Off | Each point becomes the sum of the months up to it, such as year-to-date revenue. |
| Card Comparison and Card Icon | Card type only. See Cards and text. |
Under Measures Used in Formula, the Edit Measure button opens the measure in the cube, in a new tab.
Chart options
They are under Design, below the types.
| Option | What it does | Default |
|---|---|---|
| Customize legend alignment | Align below graph, Align to the left of the chart, Align to the right of the graph or Without Subtitle. | Below |
| Enable Drilldown | A click on a period opens the value by category. See Drill-down. | Off |
| Show Drilldown as Series | Each category becomes a series. Only with drill-down on. | Off |
| Show only last period | Shows only the most recent period. | Off |
| Use categories as axis | Puts the categories on the axis instead of the dates, with the value of the last period. | Off |
| Show fixed values on the chart | Writes the values on top of each point or column. | Off |
| Compare points with | Shows the change from the previous period or from the same period last year. See Comparison and fixed values. | None |
Limit and sorting
Under Limit and Sorting, fill in Maximum number of items to show only some items and pick the Item sorting:
| Sorting | Which items stay |
|---|---|
| Highest values | The N items with the highest values (default). |
| Lowest values | The N items with the lowest values. |
| First values and Last values | The first or last N, in the order they appear. |
| Labels A to Z and Labels Z to A | The first N in alphabetical order, or in reverse. With drill-down, sorts the opened items by name. |
| Most recent dates and Oldest dates | The N items with the most recent or the oldest dates. |
Apply configuration to drilldown items applies the same limit to the drill-down items. Sorting stays disabled until you fill in the maximum number or turn on drill-down.
Below the panel, Applied filters shows the dashboard filters that apply to the chart.
Example: Revenue vs. target
In the sample project, the Revenue vs. target chart has two series:
- Revenue: the Revenue measure of the Sales cube, in Currency.
- Target: the Target measure, in Currency, with Series Type set to Line.
With the column type, revenue shows as columns and target as a line on top. In December 2026, revenue was R$ 6,184,875.00 and the target R$ 6,372,028.00: the line runs a little above the column.
Watch out
- Average and accumulated are progressive. Calculate average in chart is not the whole-year average at every point: each point is the average up to that month.
- Two scales on one axis flatten the smaller one. A percentage series next to one in millions sticks to zero. Use Plot series on another axis.
- Formatting does not change the calculation. Percentage only formats; the formula must already calculate the ratio.
- Pie, donut, funnel, gauge and card use the last period. See how each type reads the series in Chart types.
Next step
With the chart saved, put it on a dashboard: see How to build a dashboard.