Binding Data

Data fields

The Card has 3 data fields available for binding :

• Value : main value displayed on the Card
• Target : target displayed in the Card, compared to the Value
• Sparkline : series field (usually a date) to use as X Axis values on the sparkline
• Group By : Split into many widgets : how we split series of different Cards in the same container
  

Value

This represents the primary quantity we want to display as text on the Card.

See below about Value Aggregation.
This field is required.

Target Value

This represents the Target we want to display as text on the Card, and will be compared to the Value.
When this field is bound, an additional information is displayed as text : a KPI indicating how the Value compares to the Target value, which can be configured.

See below about Value Aggregation.
This field is optional.

Sparkline

This is the field (usually a date/time) used for the X Axis of the sparkline chart.

This field is optional if you don’t want to display a sparkline on the Card.

Group By : Split into many widgets

This represents the series field to generate a different contained Cards for each different value in this Series field.
Each Card will take a portion of size of the widget depending on the container shape. In order to access the other values, the user may need to scroll.
Please see the corresponding chapter to configure the Card as Widget container.

*Note :
This only works if your series are values into a single data field.

Example : If you have a field called “Equipment”, you may want to plot a completely separate Card for each value of Equipment :

Value aggregation

This Widget displays two types of values :

• the Card “summary value” displayed as text labels : Value, Target, KPI
• the sparkline chart’s Y value
  

You may configure the summary value in two different ways, under the Value category :

Value Type = Last Value

Displaying the Last Value means the last value on the sparkline chart, according to the sorting by the Sparkline field.

*Note : in this case, the Aggregate selection is ignored.

Value Type = Aggregate

Instead of displaying the last value from the sparkline chart, the Aggregate setting allows to calculate a value based on all values in the chart.
The aggregation function used to aggregate all the values in the chart is defined as the Aggregate option.

!If Value and Last are used together (i.e. Value & Target) the all data will be aggregated. Is case of average aggregation with a last value, it could cause a wrong display. Data must be analyzed to prevent Aggregation problem with different value.

Code192 2020 All rights reserved