To open Chart window, select ID or name of component in the Dashboard Components and set Chart in Type field.

1. 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.

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. Set filter in order to filter data by set criteria.                                                                                                                         

   Take care to set criteria wisely. Typically, the filter is equivalent to the WHERE statement in SQL query.

   You can set filter only in ME and MF editions.

8. Select appropriate option in the Sort Axes box.                                                    
9. Check Use "Total" for dashboard component.   

   Having checked Use "Total", the chart displays unfiltered values.

10. Enter chart name in the General box. E.g.: Receivables structure
11. If required, you can check various chart display settings in the General box. E.g.: Select 3D and Show Key.
12. Enter any description for component in the Descr. field.
13. Click Show Chart.
14. Click to confirm it.

ZEUS topics in the PANTHEON 5.5 Guide:

• Dashboard Components - Chart
• ZEUS Dashboard

Related topics:

• Create a Component