Spotfire® Web Client User Guide

Using markings for data limiting

A visualization can be configured to show only data that has been marked in another visualization or visualizations, or even show only data that has been marked within the visualization itself. That is, the configured visualization will be based on a limited amount of data, determined by what is currently marked in the limiting visualizations.

About this task

The most common use case of limiting data by markings is drilling down into details visualizations. This example shows an additional use case. It illustrates how the limited data can be retrieved from different visualizations that use different markings. When more than one marking is used to mark data in the limiting visualizations, you can combine the marked data from the different markings in two ways; an intersection (AND), or as a union (OR). The settings is available in the Data section of the visualization properties.
The example data table contains nutrition data:

Limit data to intersection of marked items

In a type of diet it is recommended to eat food with low carbohydrate values and high fat values. To identify these food items, the bar charts below are created. In the top bar chart, food items with the lowest carbohydrates values are marked using Marking A, and in the bottom bar chart, food items with the highest fat values are marked with Marking B.

About this task





Assume you wish to identify food items with low carbohydrate and high fat values. Simply create another bar chart, and make the settings shown below in its Data settings.

That is, make sure both Marking A and Marking B are selected under Data limiting, and, next to Settings for limiting markings, choose the All markings (AND) option to get the intersection of the items marked in the two bar charts. Among all food items, the items below are the ones that fulfill both the criteria:

Limit data to union of marked items

About this task

If you are instead interested in identifying food items fulfilling at least one of the criteria, that is, items with either low carbohydrate or high fat values, change Rows must be included in to Any marking (OR) to get the union of the items marked:

The items below are the ones that fulfill at least one of the criteria: