5.10. Charting Grids and Pivot Grids

The Charting tools in Aqua Data Studio are for Business Analysts and Developers who want to analyse trends in stocks or get a dynamic view of data. The features include support for Candlestick, High Low Close, Bubble, Scatter, Surface, Stacked, Area, Pie, Bar, Column, Line and Map Charts. The Function Series introduced in Aqua Data Studio are a special series that makes use of other data series for their data values. You can select any of the function series to be combined with the standard chart types already available in ADS. It also includes support for 2D and 3D coordinate systems. Advanced options to Merge Series and Scripting charts for reuse are also available.

Features of Charting Tools

• You can execute SQL Queries to produce Column Charts, Stacked Charts, Area Charts, Bar Charts, Pie Charts, Line Charts, Surface Charts, Candlestick, High Low Close, Bubble, Scatter and Map Charts
• Function Series for Add, Subtract, Scalar, Power, Log, Moving Average, Linerar Regression and Average
• Chart options include 2D and 3D views
• You can display charts in Isometric, Category and Series View
• Execute Pivot Grids and Display fields, Show Totals and Sub-totals
• Sorting and Quick Filtering are possible in Pivot Grids
• Microsoft Excel can be invoked with ADS Charting Tools. View in Excel Viewer displays the ADS charts in Excel
• The Chart layout can be saved and shared in XML. Load layout from XML opens saved XML charts
• Aggregate Functions like Count, Sum, Min, Max, Average and Standard Deviation are included in Pivot Grids
• With the Query Analyzer, you can execute query, display a chart, generate scripts and share with other developers who can re-execute and generate the same grids. This dramatically reduces the development time by allowing shared scripts and layouts

GRID and PIVOT GRID with charts in Aqua Data Studio

Grid	Pivot Grid

Grid and Pivot Grid feature can be invoked in the Query Analyzer to create a variety of Charts to represent the data in tables. Features in ADS for complex charting help minimizing the development cycle. For more on Grid Charts and Pivot Grid Charts, see the Working with Grids and Pivot Grids section.

Types of Charts available in ADS

Below are the charts which Aqua Data Studio Can generate. All of these can be built from direct quiries to any of the databases which Aqua Data Studio can connect to.

3D High Low Close	3D Candlestick	Moving Average + Stack	Functions

Cone	Pyramid	Cylinder	Exploded Pie

3D Column Chart	3D Stacked Chart	3D Stacked Area Chart	3D Bar Chart

3D Area Chart	3D Line Chart	3D Surface Chart	3D Pie Chart

2D Column Chart	2D Stacked Chart	2D Stacked Area Chart	2D Bar Chart

2D Area Chart	2D Line Chart	2D Surface Chart	2D Pie Chart

Map Chart