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. 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.
The chart table does not support pagination or searching. Please use a publication if you need a table showing hundreds, thousands or millions of rows, or if you want to add searching, pagination, exports or other publication features. The Data Publisher can handle such requests. Charts widgets cannot.
Please check the hints available in your dashboard for each chart type and make sure your SQL query meets these requirements.