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 mode to be able to add a visualization to the sheet.
- Drag the visualization from the assets panel onto the sheet, or double-click the visualization.
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.
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.
You can find master visualizations under 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 .
|Bar chart||The bar chart displays a bar for each dimension value. The bar length corresponds to its numerical measure value.|
|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||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||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||The gauge is used to display the value of a single measure, lacking dimensions.|
|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||The line chart displays data lines between values. Line charts are often used to visualize a trend in data over intervals of time.|
|Map||The map is used to combine geospatial data and measure values, such as the sales for a region or a store.|
|Pie chart||The pie chart shows the relation between a single dimension and a single measure.|
|Scatter plot||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||The treemap shows hierarchical data. A treemap can show a large number of values simultaneously within a limited space.|
|Waterfall chart||The waterfall chart illustrates how an initial value is affected by intermediate positive and negative values.|
|Filter pane||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||The KPI is used to present central performance figures. You can add a link to a sheet.|
|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||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||You can use the text & image visualization to add text, images, measures and links to a webpage.|