Charting
The Charting component of AQT gives you the ability to chart your data.
The Chart window can be invoked in a number of ways:
- from the Data Display window, click on Tools > Chart Data, or the Chart button in the toolbar
- from the Run SQL window, click on Run > Chart SQL
- from the Database Explorer window, click on a table then Table > Chart Table
When you are first building a chart for a table/query, it is highly recommended that you use the first of these options. This is because, in building a chart, AQT will frequently re-fetch the data. When building a chart from the Data Display window, AQT just re-reads the display grid. For the other methods, AQT will need to re-fetch the data from the database. This can be time-consuming, and will result in a greater load on the database server.
Charting is explained in one of the following topics:
- How Charting Works gives a good introduction to charting
- Using the Charting window gives you an overview of the use of the Charting window.
- Once you have developed some charts, you can view then in the Query Explorer window. Charts can easily be refreshed with the current data, making them a powerful way of developing a pre-build report. This is explained in more detail in the section Viewing Charts in the Query Explorer.