Skip to main content

Dashboards

A Studio dashboard is a workbook with pages for related views. Each page can contain charts, KPI cards, tables, maps, text, and filter or navigation controls. Build a workbook from a blank canvas or open a template and replace its sample data with your own.

Follow Build and publish a revenue dashboard to create a regional chart and KPI, then test standard and presentation views.

Browse the Dashboard widget reference for all 106 picker tiles, including custom charts, required data fields, result examples, styling controls and supported interactions.

Create a dashboard​

  1. Open Dashboards in the sidebar and choose New dashboard. Name the workbook and describe what its numbers measure.
  2. Open Edit dashboard. Use Add page to organize the workbook and Add widget to open the chart picker.
  3. Pick a chart or layout element. For a data widget, choose its source and map fields to the chart, such as date to the horizontal axis and revenue to the value axis.
  4. Preview the output, inspect its columns and rows, and save the widget. Use the same dataset for related widgets if they should share definitions and filters.

The picker includes standard series, scatter, donut, map, and table views as well as comparison KPIs, rankings, funnels, gauges, treemaps, and trend grids. The chart editor exposes styling, field mappings, and interactions for each type. Tiles with starter queries give you a field shape to compare with your own data. Check the source before putting a starter widget on a shared dashboard.

Choose how to provide data​

SourceUse it when
Visual query in a widgetYou want to select tables and build a query with controls for relationships, filters, calculations, grouping, and output.
Dashboard dataset in DataSeveral widgets need the same query or visual recipe. Create the dataset once, preview it, and bind widgets to it.
Published flow versionA flow prepares and validates data that you want to reuse in one or more dashboards. Attach a live dataset.
SQL editor in a widget or datasetYou want to use a validated read query or need SQL features outside the visual builder.

Use a persisted catalog table or view as the starting point. If you have a source file, load it into a queryable table and check its types and row count first. Connect to the intended catalog and schema. Use an authorized viewer account when checking a shared workbook.

Build a revenue chart without writing SQL​

This example assumes a table with one row per order and fields order_date, branch, and revenue. Use your own field names in the builder.

  1. In edit mode, open Data and create a dataset with Visual builder selected. Under Source & relationships, select the connection and the order table.
  2. Under Preparation & measures, group by branch and add a measure that sums revenue. Add a date restriction if you want a specific reporting period.
  3. Under Output, choose the branch field and the revenue measure. Select Preview dataset and check that the result has one row per branch. Compare the total across branches with a known result for the same period.
  4. Save the dataset. Add a horizontal bar chart, select the saved dataset, and bind branch to the category and the revenue sum to the value. Set the currency format and a descending sort, then save the widget.

If your source already contains regional or monthly summaries, check its grain before joining or aggregating again. For rates, sum the numerator and denominator at the desired grain before dividing. Inspect unmatched or duplicated keys when totals change after a join.

Continue with Layout, filters, and interactions, then Publish and share a dashboard.