The Function Series introduced in Aqua Data Studio is a special series that make 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 > Series when viewing a chart created from Query Results.
For each of the series, you may also enable the display of the function metadata. The Linear Regression function contains the Slope and Y-Intercept as the metadata 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)
- Execute the query in the Query Analyzer, select Category, and Series for a Chart Type.
- To add a Function Series, click Chart Options.
- Go to the Chart Options. Click the icon with a '+' sign which says Add Function Series.
- In the Chart Options pane, locate the newly added function series.
- Click Function Drop Down within the Series Options for Add, Subtract, Scalar, Power, Log, Moving Average, and Linear Regression.
- You can specify Function Parameters as a comma-separated list of values.
- For Function series Linear Regression slope and y-intercept you can display Function Metadata.
|
|
|
|
|
|
|
| 1. Execute Query Pick Category and Series | 2. Click Chart Options Icon | 3. Click + Add Function Series in Chart Options | 4. Locate the new Function Series at the 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 - Average
Average sums all values in a series and divides that sum by the total number of rows/samples. This value is then plotted as a horizontal line. This is useful for visually comparing a series' data points against the average for those data points.
