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

2 Replies to “Chart Widgets”

  1. Hi, Is there a way to make the chart dynamically update from the results of a Data Publishing Table? i.e can you pass the results of a dataset from a table to a chart? I’d like to have the chart automatically update as the user scrolls the results. Thanks Mitchell

    1. Hi Mitchell,

      Interesting thought!

      There is a getChartData() function which sends a request to get the chart data. Function refreshChart() then updates the chart. You could overwrite the chart data and call refreshChart() interactively. Some updateChartData() function should work and would need to be called from your publication. Can be done!

      We currently don’t have the time as we are working on a huge website update. If you have JavaScript skills you might be able to do it. Or is anyone else reading this interested? Let me know…

      It’s on our to do list! But I cannot give you an ETA at this time. Sorry.

      Thanks!
      Peter

Leave a Reply

Your email address will not be published.