You can use visualizations to present the data that is loaded into the app. For example, you can use a bar chart to compare sales numbers for different regions, or use a table to show precise values for the same data.

The selections you make in a visualization are reflected in all associated visualizations on all sheets.

Creating a visualization

You create visualizations from pre-defined charts or custom objects. You must be in Edit Edit mode to be able to add a visualization to the sheet.

  1. Drag the visualization from the assets panel onto the sheet, or double-click the visualization.
  2. Add dimensions and measures to the visualization. The number of dimensions and measures that are required depends on which visualization you selected.

    Dimensions determine how the data in a visualization is grouped - for example total sales per country or number of products per supplier. For more information, see Dimensions.

    Measures are calculations used in visualizations, typically represented on the y-axis of a bar chart or a column in a table. Measures are created from an expression composed of aggregation functions, such as Sum or Max, combined with one or several fields. For more information, see Measures.

  3. Adjust the presentation, for example sorting, coloring, or labeling.

    For more information, see Changing the appearance of a visualization.

You can convert from one visualization type to another by dragging a new chart to a visualization on a sheet.

For other methods of creating a visualization, see Creating and editing visualizations.

Reusing a visualization

If you have created a visualization that you want to reuse in other sheets of the app, you can save it as a master visualization. You can only create master visualizations in an unpublished app. When the app is published, all users can add the visualization to their own sheets, but not modify it.

Tip: Right-click on a visualization and select master items Add to master items to save it as a master visualization.

You can find master visualizations under master items in the assets panel.

Which visualizations are available?

There are two basic types of visualizations available in the assets panel.

  • Charts illustrate the data with visual elements like bars, lines, or points.
  • Text-based visualizations presents data in text form, for example, tables or filters.

The best choice of chart type depends on the purpose of the visualization.

For more information, see When to use what type of visualization.

If the pre-defined visualizations does not fill your purpose, you can use a visualization extension or a widget. You find them in the assets panel under Extension .

Chart Icon Description
Bar chart Vertical bar chart The bar chart displays a bar for each dimension value. The bar length corresponds to its numerical measure value.
Box plot Box plot The box plot is suitable for comparing range and distribution for groups of numerical data, illustrated by a box with whiskers, and a center line in the middle.
Combo chart Combo chart The combo chart combines bars and lines in the same chart. The bars and lines have different axes to enable comparing percentages and sums.
Distribution plot Distribution chart The distribution plot is suitable for comparing range and distribution for groups of numerical data. Data is plotted as value points along an axis.
Gauge Guage chart The gauge is used to display the value of a single measure, lacking dimensions.
Histogram Histogram The histogram is suitable for visualizing distribution of numerical data over a continuous interval, or a certain time period. The data is divided into bins.
Line chart Line chart The line chart displays data lines between values. Line charts are often used to visualize a trend in data over intervals of time.
Map Map The map is used to combine geospatial data and measure values, such as the sales for a region or a store.
Pie chart Pie chart The pie chart shows the relation between a single dimension and a single measure.
Scatter plot Scatter chart The scatter plot presents values from two measures. This is useful when you want to show data where each instance has two numbers, for example, country (population and population growth). An optional third measure can be used and is then reflected in the size of the bubbles. When showing large data sets colors will be used instead of bubble size to represent the measure size.
Treemap Tree Map The treemap shows hierarchical data. A treemap can show a large number of values simultaneously within a limited space.
Waterfall chart Waterfall The waterfall chart illustrates how an initial value is affected by intermediate positive and negative values.
Text-based visualizations
Chart Icon Description
Filter pane Filter container The filter pane allows you to control what data that is shown in the visualizations on a sheet. A filter pane can filter the data of several dimensions at once.
KPI KPI  The KPI is used to present central performance figures. You can add a link to a sheet.
Pivot table Pivot table The pivot table presents dimensions and measures as rows and columns of a table. The pivot table allows you to analyze data in multiple dimensions at a time. The data in a pivot table may be grouped based on a combination of the dimensions, and partial sums can be shown.
Table Table The table displays values in record form, so that each row of the table contains fields calculated using measures. Typically, a table includes one dimension and multiple measures.
Text & image Text You can use the text & image visualization to add text, images, measures and links to a webpage.