Dashboard diagram widget configuration
This information is also applicable to the field Visual extra: SQL: Diagram query.
This site only describes the specifics of the diagram widgets, for general widget configuration click here.
This article will only cover the newest version of graphs implemented.
To enable these, toggle the Policy useGoogleChart to false and useNewChart to true.
As of writing (version 8813) these renderings are supported.
- Circle
- Doughnut
- Bar vertical (Columns)
- Bar horizontal
- Area
- Line
- Area (stacked)
Data
An SQL Query may extract almost anything from the database.
This process ignores the security restrictions in the system, so you will have to implement them yourself.
Circle diagrams
XY diagrams
Internationalization
Graph defaults
The graphs all reference the js object tsChartDefaultOptions, with a couple of tweaks.
To see the defaults, open the terminal in you browser, on a page that has a graph and type the name of the object.
Specifik defaults
These can't be overwritten.
Area stacked
options.scales = {
y: {
stacked: true
}
}
Bars
options.indexAxis = 'y'
Overwriting defaults
To overwrite the default of all charts:
Define an object in js, named tsChartOverwriteOptions.
Set it based on the documentation fund here.
To overwrite the options for a specific chart:
Define an object in js, named tsChartOverwriteOptions.
Add an object with an index matching the chartID.
Set it based on the documentation fund here.
To test your overwrite:
From the console in the browser call tsChartOptions with the only parameter being the chartID.
The return will be the final options, that will be used for that chart.