1. Home
  2. Docs
  3. Dashboards and Widgets
  4. Chart Widgets

Chart Widgets

Charts are new in version 5. The following chart types are supported:

Each chart type needs its own data set. Data sets are created using SQL queries. Please check the hints available for each chart type and make sure your SQL query meets these requirements. Use the Query Builder to test your queries before you use them to create a chart.

Make sure your query does not return thousands of rows. This will slow down your server, and charts showing thousands of values are useless anyway. Use a publication if you need a table showing hundreds, thousands or millions of rows, or if you want to add advanced searching, export buttons or other publication features.

Advanced chart options

Advanced chart options allow plugin users to add Google Charts options which are not available through the user interface. Options need to be entered in valid JSON. Invalid JSON is rejected! Use the Check JSON validity button before you close the popup.

Examples

3D pie chart

The following example turns a pie chart into a 3D pie.

Option

{ 
  "is3D": true
}

Customizing axes

The following example sets the vertical axis baseline to 0.

Option

{
  "vAxes": {
    "0": { "baseline" : 0 }
  }
}

Notes

  • The chart widget supports remote database connections. Please make sure the remote user has the SELECT and CREATE TEMPORARY TABLES privileges.

Further reading

Was this article helpful to you? Yes No

Leave a Reply

Your email address will not be published.

16 + 2 =