Chart

Chart

1. Enter any name and description for component in Name and Description field. 
2. Paste an SQL query in the SQL box. It cannot exceed 8000 characters. Right-click and select Edit in SQL Editor command from the menu if you want to edit SQL query in editor.

2. To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data. After selecting this option, click Apply SQL. You have to click it also whenever you change an SQL query. 

    

3. Click Apply SQL.
4. Select type of chart in the Chart Type box (that is, line chart - vertical, line chart - horizontal, area chart - vertical, area chart - horizontal, scatterplot, column chart - vertical, column chart - horizontal, pie chart). E.g.: Line chart - vertical

​

5. In Link Data box set data to display on X and Y axis. E.g.: axis X -> Month, axis Y -> Sales 06.

​

6. To display multiple data series obtained from various SQL query columns, add a new record in Link Data and follow the procedure mentioned in the previous item. Add new records using down arrow key , or .

​

7. Select appropriate option in the Sort Axes box.
8. Check Use "Total" for dashboard component. Having checked Use "Total", the chart displays unfiltered values.
9. If required, you can check various chart display settings in the General box. E.g.: Select 3D and Show Key, Use different colors or Show Values in Field.

​

10. Click Show to recreate chart in view window.
11. Click to confirm it.