DefinitionDescriptionValuesExamples
charttype=;Sets the type of the chart.area, bubble, column, donut, funnel, bar, line, pie, polar, pyramid, spline, splinearea, columnstacked, barstacked, areastackedcharttype=donut;
height=;Sets the height of the chart (in "pixel" or as a percentage of the display).px or as % of the displayheight=50%;
height=200;
backgroundcolor=;Sets the color of the charts background.hex codebackgroundcolor=#1DE9B6;
showdatamarker=;Sets the data markers (labels) above a chart.true/false
default: true for donut, pie funnel, pyramid, false otherwise.
showdatamarker=true;
seriescolor=;Sets the color of all series in a chart.hex codeseriescolor=#1DE9B6;
axiscolor=;Sets the color of the x and y axis.hex codeaxiscolor=#ff5600
seriescaptions=,;Sets the title of each particular series.valueseriescaption=Revenue,Forecast;
colorpalette=,,;Sets the color of each chart value.hex code
default: false
colorpalette=#1DE9B6,#FF0060,#455a64;
showlegend=;Sets the chart legend.true/false
default: true for donut, pie funnel, pyramid, false otherwise.
showlegend=false;
legendtextcolor=;Sets the color of the legend text.hex codelegendtextcolor=#1DE9B6;
titletextcolor=;Sets the color of the title (caption of the element) as well as of the axis captions (xaxiscaption, yaxiscaption).hex codetitletextcolor=#1DE9B6;
xaxiscaption=;Sets the caption for the x axis of the chart.valuexaxiscaption=time;
yaxiscaption=;Sets the caption for the y axis of the chart.valueyaxiscaption=customers;
horizontalaxislabelrotation=;Defines the angle of the labels on the horizontal axis of the chart.0-360
default: 0
horizontalaxislabelrotation=45
verticalaxislabelrotation=;Defines the angle of the labels on the vertical axis of the chart.0-360
default: 0
horizontalaxislabelrotation=45
numberformat=N0; (N1, N2, Nx)
numberformat=P0; (P1, P2, Px)
numberformat=F0; (F1, F2, Fx)
Sets the number format of the values (if it is a number) in the data markers and axes.

N0 is a number without decimal place. N1 with one, N2 with two, ...

Px stands for a percentage value with x decimal.

Fx stands for integral and decimal digits with optional negative sign.
N - Precision specifier: Desired number of decimal places.

P - Precision specifier: Desired number of decimal places.

F - Precision specifier: Number of decimal digits.
numberformat=N2; > 1,234.57
numberformat=P2; > 12.57%
numberformat=F4; > 1234.5600
primaryaxistype=;Sets the scale of the axis for optimal formatting.category, numeric, datetimeprimaryaxistype=datetime;
enablezooming=;Used to enable/disable the pinch zooming.
Chart allows you to zoom in to view the data clearly.
true/false
default: false
enablezooming=true;
linkinfo=;By adding the definition linkinfo=component:,type:filter,data:; to your chart you can use the columns for filtering the list contained in your app.

Example App: https://get.openasapp.net/l/app/6f74412f-73bf-4c23-8b18-71c2f90c5704

Remove other filters after the jump

The abovementioned flag can be extended so that old filters are removed after the jump before the new one is set.

linkinfo=component:,type:filter,clearfilters:true,data:;
linkinfo=component:3ZosGzRM,type:filter,clearfilters:true,data:Country;
showlabelforundefinedvalues=;Undefined values (like #N/A) are not shown in the chart. To deactivate this behavior users can add this definition.true/false
default: false
showlabelforundefinedvalues=false;

📘

Use charts for filtering a list

By adding the definition linkinfo=component:list,type:filter,data:; to your chart you can use the columns for filtering the list contained in your app.

Example App: https://get.openasapp.net/l/app/6f74412f-73bf-4c23-8b18-71c2f90c5704

In the example above we used our well known salespeople list.
We added two pivot tables there:

  1. Column "Sales last year" summed by column "Country"
  2. Column "Sales YTD" summed by column "TerritoryName"

Each table is also available as a chart. We added each of them to our list application....