Stacked Columns Chart
Last updated
Last updated
The Stacked Columns Chart shows the contribution to trends in the data. This is done by stacking lines on top of each other. Stacked Line charts are used with data that can be placed in an order, from low to high. The charts are used when you have more than one data column that all adds up to the total trend.
You can find a more in depth explanation about the stacked column on this page: https://apexcharts.com/javascript-chart-demos/column-charts/stacked/
Datamodel
The Stacked Columns Chart uses a single list or filtered list for its source values. This list has the fields for the Series and Categories on each row. From this list a field is selected for the 'Values', the widget will then iterate over this list and use the indicated field to generate the values shown in the widget. This field must be numeric type. The categories and series properties are then set to respective category and series field from the source list. So this list will contain the following:
Numeric field, for holding the values to show on the stack - per specific category and series
Text field, to hold the specific Category value that is displayed along the other axis from the values: for example, the Month Name to show values per month.
Text field, to hold the specific Series value for which the Value should be applied (like years, and if they hold a numeric value, just use the ToString([field]) in the widget property) for example to show the different Total Values for the same month in Categories but with a different color per year.
Properties of Stacked Columns Chart
Property Name
Data type
Type
Description
Data source
List
Data Model
Data sourcelist for the widget.
Series
Text
Expression
This field is used to create
different groups from the
same data source.
It's not required.
Categories
Text
Expression
To set the categories of the chart.
Values
Number
Expression
Values to be used for each
series.
Horizontal
Boolean
To set or not in horizontal form., (yes, no).
Height
Number
Expression
Set height of the chart.
Type number.
Value Prefix
Text
Expression
To set the value of the prefix.
Value Postfix
Text
Expression
To set the value of the postfix.
Tool Tip Prefix
Text
Expression
To set the prefix of the tooltip.
Tool Tip Postfix
Text
Expression
To set the postfix of the tooltip.
Show Data Labels
Boolean
Expression
Display the labels on
render.
Label Decimals
Number
Expression
To set the quantity of decimals of the labels.