|
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 and Line 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 Charts
- Function Series for Add, Subtract, Scalar,
Power, Log, Moving Average and Linerar Regression
- 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.
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 |
|
|
