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)

  1. Execute the query in the Query Analyzer, select Category, and Series for a Chart Type.
  2. To add a Function Series, click Chart Options.
  3. Go to the Chart Options. Click the icon with a '+' sign which says Add Function Series.
  4. In the Chart Options pane, locate the newly added function series.
  5. Click Function Drop Down within the Series Options for Add, Subtract, Scalar, Power, Log, Moving Average, and Linear Regression.
  6. You can specify Function Parameters as a comma-separated list of values.
  7. For Function series Linear Regression slope and y-intercept you can display Function Metadata.

1. Execute Query Pick Category and Series2. Click Chart Options Icon3. Click + Add Function Series
in Chart Options		4. Locate the new Function Series at the bottom5. Click Function Drop Down Select Function6. Specify Function Parameters7. 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.


Function Series Add

Function Series Subtract

Function Series Scalar

Function Series Power

Function Series Log

Function Series Moving Averages

Function Series Linear Regression

Function Series Average