Mapping data to controls

Bind data to dashboard controls in the application.

Footer function

Mapping data to controls is available in the supporting footer below the canvas. If a control has the ability to bind data, the mapping option becomes visible in the footer bar.

General

In general the best way to approach data mapping is to refer to the dataclip as a table structure consisting of rows and columns.

To determine a single value from this structure a column (header) and row (occurence) is needed.

When multiple values from multiple rows are needed system will need to know which columns and rows are needed.

Mapping types

A general note here regarding mappings:

• By default all rows in a data set are targetted.

• Filtering to these rows are commonly applied by configuring these as links or filters.

• Use the option "swap mappings" if you want to change rows to headers (and vice versa).

The software supports the following types of mappings:

Single header mapping:

This mapping requires a single header or column form a dataclip to be mapped to a property.

Examples:

• A dropdown which should show all unique values under a header.

• A label that shows a specific value under a header based on a filtered or chosen line from a dataclip.

Multi header mapping:

This mapping requires multiple headers or columns from a dataclip to be mapped to a property.

Examples:

• A grid that should show multiple colums from a dataclip.

• A graph that should show lines for multiple data points.

Single dataclip:

This mapping requires a single dataclip to be mapped to a property.

Examples:

• A dropdown that should show a list of unique values (based on the header that is marked as unique value holder).

• Rare cases where headers are determined through links and a mapping is needed to trigger data retrieval.

Extended mappings:

This type of mapping is available depending on the chosen control/properties and/or the relationship to other (linked) controls and/or properties. In those cases the option will appear in the mapping Toolbar or can be accessed via "Switch view".