In this article we'll provide information on how to create and customise the Grid tile type in Calxa dashboards.

Bind Data

Each tile type allows you to bind data in a similar way, however each tile will have different data properties. This section describes the data properties specific to a Grid dashboard tile.

Columns

Select what data you would like to display in each column.

Column Types

Each column can be displayed as one of 5 types.

Dimension Column

Dimension columns are used to provide discrete categorical information from which the values in other columns are grouped. The first column 'Profit & Loss' in the example above is a dimension with AccountTreeRowName being the dimension to group by.

Measure Column

Measure columns are used to display aggregated or summarised data. Use the Summary Type to determine what method is used for summarising.

Display Mode

Measure columns can optionally be displayed as bars or values.

Delta Column

Delta columns calculate the difference between 2 values. The values do not need to be defined as other columns in the grid, but rather are defined in the delta column configuration. Define an actual and a target value to calculate the delta and the difference will be displayed with a delta indicator.

Delta Options

Option	Description
Display Mode	Delta columns can be displayed as Bars or Values.
Value Type	Specifies which values should be displayed as the delta value.
Result Indication	Specifies the condition for displaying the delta indicator as red or green.
Threshold Type	Specifies the comparison tolerance in percentage values or in absolute values.
Threshold Value	Specifies the comparison tolerance value. If the delta value is between the positive and negative Threshold, the delta value is gray and no indication is displayed.

Sparkline

Sparkline columns visualise the summary value changes over time.

Sparkline Options

You can control sparkline appearance settings using the Sparkline Options.

Option	Description
Show start/end values	Specifies whether to display sparkline start/end values within a grid cell.
View type	Defines the sparkline’s view type. Sparkline data points can be represented as area, line, bars, or win and loss squares.
Highlight min/max points	Specifies whether to highlight a sparkline’s minimum/maximum points.
Highlight start/end points	Specifies whether to highlight a sparkline’s start/end points.