9.6 Function Series

The Function Series introduced in Aqua Data Studio 7.5 are a special series that makes use of other data series for their data values. The function series have a lot of options which is configurable. You can select any of the function series to be combined with the standard chart types already available in ADS.

Function - Add	Function - Subtract	Function - Scalar	Function - Power
Function - Log	Moving Average	Linear Regression

Chart Function Series

In the Advanced tab, you have the ability to add and remove virtual function series. 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

For each of the series you may also enable the display of the function meta data.  The Linear Regression function contains the Slope & Intercept as the meta data.

Getting Started with Function Series

    * Execute the query in the Query Analyzer, select Category and Series for a Chart Type
    * To add a Function Series, click on Chart Options
    * Go to the Advanced Tab
    * Click on the icon with a '+' sign which says Add Function Series
    * In the options pane and locate the newly added function series properties
    * Click on Function Drop Down for Add, Subtract, Scalar, Power, Log, Moving Average and Linear Regression
    * You can specify Function Parameters as comma-separated list of values
    * For Function series Linear Regression slope and y-intercept you can display Function Meta data

Chart Options -> Advanced Tab -> Add Function Series Icon