|
The Function Series introduced in Aqua Data
Studio are a special series that makes use of other data series for
their data values. The function series have several options, all of
which are configurable. You can select any of the function series
to be combined with the standard chart types already available in
ADS. These series are considered Virtual Series, as Aqua Data
Studio generates the series based on user settings within the Chart
Options -> Advanced tab when viewing a chart created from Query
Results.
For each of the series you may also enable the display of the
function meta data. The Linear Regression function contains
the Slope and Y-Intercept as the meta data and displays them within
the chart when "Show Function MetaData" is enabled.
Using Function Series
Below are the steps to add a function series to an existing
chart. (See the Working with Pivot Grids and Charts for more
information on Pivot Grid Charts and Grid Charts)
1. Execute the query in the Query Analyzer, select Category and
Series for a Chart Type
2. To add a Function Series, click on Chart Options
3. Go to the Advanced Tab. Click on the icon with a '+' sign
which says Add Function Series
4. In the Chart Options pane, locate the newly added function
series
5. Click on Function Drop Down within the Advanced Chart Options
for Add, Subtract, Scalar, Power, Log, Moving Average and Linear
Regression
6. You can specify Function Parameters as comma-separated list
of values
7. For Function series Linear Regression slope and y-intercept
you can display Function Meta data
|
|
|
|
|
|
|
1. Execute Query
Pick Category and
Series |
2. Click Chart
Options Icon
|
3. Click +
in Advanced
Chart Options
|
4. Locate new
Function Series
at bottom
|
5. Click Function
Drop Down Select
Function
|
6. Specify Function
Parameters
|
7. Show Function
Meta Data
Linear Regression
|
The current functions that may be used are:
- Add
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Second Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Result: For every row of data, add First Series value to Second
Series value
- Subtract
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Second Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Result: For every row of data, subtract Second Series value from
First Series value
- Scalar
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Second Parameter: Scalar Value
Result: For every row of data, multiply Series value by
Scalar
- Power
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Second Parameter: Exponent
Result: For every row of data, find Series value to the Exponent
power
- Log
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Second Parameter: Logarithm Base
Result: For every row of data, find the logarithm of Series
value
- Moving Average
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Second Parameter: Count of data points to average
Result: For every row of data, find the average of the Series
values for this row and Count - 1 preceding rows
- Linear Regression
First Parameter: Series Number (1 indicates first series, 2
indicates second, ...)
Result: Perform a least-squares regression analysis on the Series
values
|
|
