The Card displays a sparkline which is a mini-chart that gives an idea of the trend of the KPI.
It uses Field Value as Y axis and field Sparkline for the X axis. Depending on the aggregation it could impact the data visualization.

Sparkline Scale

The vertical Scale of the sparkline chart can be configured, in % of the height of the row :

  • 1 means to take the full height of the row
  • 0.9 means almost the full height
  • 0.1 means a very thin display

Card Sparkline Scale configure

Sparkline Color

The Color Type of the sparkline chart can be :

  • the Direction Color that depends on the distance between the Value and the Target, and whether we consider that “good” or “bad” (see “Colors and result interpretation”)
  • or a Custom Color that is fixed

The Opacity of the color can also be configured.

Card Sparkline Color configure

Sparkline Interpolation

The sparkline chart is interpolated.
Available interpolation methods are :

Card Sparkline Interpolation configure

basis

A cubic basis spline
The result is a smooth curve which doesn’t exactly pass through the data points themselves.

Card Interpolation Basis example

linear

A series of interconnected lines.
The result is that of a line chart.

Card Interpolation Linear example

monotone

A cubic spline that preserves monotonicity in y, assuming monotonicity in x.
The result is a smooth curve which goes through all data points and doesn’t overshoot.

Card Interpolation Monotone example

step

A step line centered on the data point.
The result is a step line which is constant around the data points.

Card Interpolation Step example

step-after

A step line starting on the data point.
The result is a step line which is constant after the data points.

Card Interpolation Step After example

step-before

A step line ending on the data point.
The result is a step line which is constant before the data points.

Card Interpolation Step Before example

Sparkline impact on the main value

When value is selected for the fields Value and Target, the card widget will get all data from the datasource and aggregate them (or use last) by the card properties (right panel)
If there is no sparkline used for the widget, the best practice is to use the aggregation on the fields (left menu)

The sparkline will split the data in function of the selected field. For duplicate data (i.e. same datetime) they will be grouped and aggregated in function of the aggregation type of the fields Value & Target Since the data will be processed, it may impact your widget main value. To prevent any trouble using the spakline, the widget should be configured with :

  1. Set Value & Sparkline fields as Value :
  2. Open filter editor :
  3. Uncheck Distinct values only :
  4. In the right panel, use aggregate and select the type of aggregation needed :
Last modified: Apr 18, 2023

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment