Working with visualizations
When a new visualization is created, a suggestion of what to visualize is created by default. You can then modify the visualization to show the values you are interested in by changing the columns shown on various axes, changing the aggregation, the coloring, etc.
Columns and aggregations are changed using the column selectors directly in the visualization, whereas appearance settings are specified using the visualization properties. Right-click the visualization, and select Properties in the opened menu, to change properties.
- Selecting columns on an axis
When creating a visualization, you select which data columns to show on various axes such as on the X-axis, the Y-axis and the color axis. - Hierarchies
Data can be organized in a specific order where each value is either above or below in relation to the other values. Usually in this hierarchical structure, the most general value is at the top and the most detailed one is at the bottom. - Aggregating data
Visualizing data involves presenting aggregated values of the data you have loaded. Examples of aggregated values are sums, averages, counts of occurrences, or results from various statistical calculations. That is, they represent collections of data as single values. In most cases, the data to aggregate is numerical, but also non-numerical data can be aggregated. - Adjusting scales on axes
By default, there is only one scale on an axis, and all measures are shown on this scale. If the measures are of completely different magnitudes, or use different units, you might benefit from using other options, for example, adding more than one scale on an axis to visualize the measures. - Adding a zoom slider
Zoom sliders are used to get a closer look at details in your visualization. - Changing display name for an axis
You can specify your own display name for an axis. - Showing/hiding the legend
The legend provides information that helps the viewer identify what is represented in a visualization. You can decide whether or not the legend should be visible. - Showing gridlines
You can add gridlines to the visualization background to make it easier to get a reading of the value for an item. Gridlines are dotted lines that are drawn horizontally or vertically from the tick marks on numerical axes. - Marking
The action of marking visualization items means selecting parts of the data that you find of certain interest to examine in more detail, or to work at in various ways. To gather the marked items, and to recognize them as marked, they are associated with a certain marking. - Working with colors
Colors can be used to add further information to a visualization. You can color items to, for example, draw attention to certain items, distinguish particular categories of data, present variation in values, or identify outliers. - Error bars
Data might not always be precise, for example, in measurement data error margins might exist. When there is a need to visualize the uncertainty in the data, you can use error bars to indicate statistical probabilities of errors, or actual errors. The error bars represent upper and lower limits of the data relative to a marker's value, and they can be added to markers in bar charts, line charts, and scatter plots. - Information and warnings
If something is off, you might see information or warning icons in different places in the analysis. You can often hover with the mouse pointer or click the icon to see more information. - Adding data limitations for a visualization
The default behavior when adding a new visualization is that it is automatically updated with the filtering on the page. However, it is possible to change the data limiting so the visualization is not changed by filtering at all, or so that it uses another filtering scheme. You can also make the visualization respond to one or more markings in other visualizations (often called details visualizations). Other options to limit the data is by using expressions, or, for streaming data, by specifying time ranges. You can change the data limitation settings under Data in the Visualization properties. - Renderer settings
If the data in a column can be shown as something other than text, like a link, an image, or a shape, you can configure this using the renderer settings in the visualization properties. The renderer settings is available in some visualizations only, for example in tables, but might also be used in some labels or tooltips. - Updating a visualization that needs a manual refresh
If a visualization is based on an on-demand data table not configured to load data automatically, or if a visualization is based on a calculated data table (for example, visualizations created using the data relationships tool in the installed client) you must manually update the visualization when the input has changed.
- Selecting columns on an axis
When creating a visualization, you select which data columns to show on various axes such as on the X-axis, the Y-axis and the color axis. - Hierarchies
Data can be organized in a specific order where each value is either above or below in relation to the other values. Usually in this hierarchical structure, the most general value is at the top and the most detailed one is at the bottom. - Aggregating data
Visualizing data involves presenting aggregated values of the data you have loaded. Examples of aggregated values are sums, averages, counts of occurrences, or results from various statistical calculations. That is, they represent collections of data as single values. In most cases, the data to aggregate is numerical, but also non-numerical data can be aggregated. - Adjusting scales on axes
By default, there is only one scale on an axis, and all measures are shown on this scale. If the measures are of completely different magnitudes, or use different units, you might benefit from using other options, for example, adding more than one scale on an axis to visualize the measures. - Adding a zoom slider
Zoom sliders are used to get a closer look at details in your visualization. - Changing display name for an axis
You can specify your own display name for an axis. - Showing/hiding the legend
The legend provides information that helps the viewer identify what is represented in a visualization. You can decide whether or not the legend should be visible. - Showing gridlines
You can add gridlines to the visualization background to make it easier to get a reading of the value for an item. Gridlines are dotted lines that are drawn horizontally or vertically from the tick marks on numerical axes. - Marking
The action of marking visualization items means selecting parts of the data that you find of certain interest to examine in more detail, or to work at in various ways. To gather the marked items, and to recognize them as marked, they are associated with a certain marking. - Working with colors
Colors can be used to add further information to a visualization. You can color items to, for example, draw attention to certain items, distinguish particular categories of data, present variation in values, or identify outliers. - Error bars
Data might not always be precise, for example, in measurement data error margins might exist. When there is a need to visualize the uncertainty in the data, you can use error bars to indicate statistical probabilities of errors, or actual errors. The error bars represent upper and lower limits of the data relative to a marker's value, and they can be added to markers in bar charts, line charts, and scatter plots. - Information and warnings
If something is off, you might see information or warning icons in different places in the analysis. You can often hover with the mouse pointer or click the icon to see more information. - Adding data limitations for a visualization
The default behavior when adding a new visualization is that it is automatically updated with the filtering on the page. However, it is possible to change the data limiting so the visualization is not changed by filtering at all, or so that it uses another filtering scheme. You can also make the visualization respond to one or more markings in other visualizations (often called details visualizations). Other options to limit the data is by using expressions, or, for streaming data, by specifying time ranges. You can change the data limitation settings under Data in the Visualization properties. - Renderer settings
If the data in a column can be shown as something other than text, like a link, an image, or a shape, you can configure this using the renderer settings in the visualization properties. The renderer settings is available in some visualizations only, for example in tables, but might also be used in some labels or tooltips. - Updating a visualization that needs a manual refresh
If a visualization is based on an on-demand data table not configured to load data automatically, or if a visualization is based on a calculated data table (for example, visualizations created using the data relationships tool in the installed client) you must manually update the visualization when the input has changed.