|
Query Window - Grid Results - Grids and
Grid Charts
Grid results displays data in tables within a grid that can be
sorted and rearranged.
Column data can be Sorted in descending
or ascending order by left clicking on column headers
 |
 |
Click on
Header
|
Sorted Rows
|
Columns can be Rearranged left to right
by dragging them from one location to another
 |
 |
Drag Column
|
Rearrange
|
Quick Filter - There is a quick Filter
on the grid with which you can focus on a particular field. When
you type in the quick filter, an "X" appears at the end of the
filter that erases the text entered when it is click on. You can
also produce a chart of the filtered data the same way that you
produced a chart of the whole block of information
 |
 |
Before Filtering
|
Using Quick Filter
|
Aggregate Functions - Aggregate
Functions allow users to calculate Count, Count Numbers, Sum, Min,
Max, Average, and Standard Deviation functions on the grid data
highlighted. Once data has been highlighted in the grid, right
click on the Aggregate Functions button at the top right of the
grid. Choose the desired function and its results are displayed
within the button itself
 |
Aggregate Functions
|
Script to Window - Automatically
generates Aqua
Commands for the pivot grid/pivot chart for exporting by right
clicking within the grid view. This Aqua Command will include all
of the settings of the grid/graph display. If these settings are
stored with a query, users can reexecute and generate the same
grids and graphs again as many times as needed
 |
 |
Script to
Window
|
Aqua Commands
|
By using "Save As" from within the query
toolbar, it is possible to save the query and Aqua Commands
together in a shared directory so that multiple users of Aqua Data
Studio can access the layout and results
 |
|
Save As |
View in Excel Viewer - Displays selected
data from the grid in Excel or Excel Viewer
 |
Excel
Viewer
|
Grid Printing - Allows printing of grid
results. Print margins are adjustable
 |
ADS Printing Options
|
|
