Available when Mode is set to Algorithm. 

Choose from the drop down list:

• Cumulative Sum - shows the running total of the data valuesMean - plot a chart line at the average

• Cumulative Percent - shows the total percentage accumulated at each point in the data series

  Tip
  Cumulative Percent reflects the cumulative contribution or impact of each percentage value as it progresses over time or through a particular set of data.

  
  

• Mean - shows the average value 
• Minimum - shows the smallest value 
• Median - plot a chart line at  shows the middle value, when the data is ordered ascending
• Maximum - shows the largest value 

• Standard Deviation - plot a chart line to display how  shows how spread out the values are from the mean

  Tip
  Standard Deviation helps to understand the dispersion or variability of the data points. A larger standard variation indicates that the values are more spread out from the mean.

• Maximum - plot a chart line at the largest value 
• Minimum - plot a chart line at the smallest value 

  
  

• Sum - plot a chart line at  shows the result of adding all values together

  Cumulative Percent - plot a trend line showing the total percentage accumulated at each point in the data series

  Tip
  Cumulative Percent reflects the cumulative contribution or impact of each percentage value as it progresses over time or through a particular set of data.

  Value - plot a chart line at the result of adding each recordset's values together individually
  • See Value below for adding the values from each recordset individually
• Cumulative Sum - plot a trend line showing the running total of the data values
• • For a multi-series chart, this will be the sum for each column of data 
  • For a single-series chart, this will be the sum of all values

Sum for Multi-Series Chart
Image Added

Sum for Single-Series Chart

Image Added

For an example chart setup using this option, see Creating a Custom Chart (Trends).

Available when Mode is set to Percentile. 

Enter a number between 0 and 100.

For an example chart setup using this option, see Creating a Custom Chart (Trends).

Available when Mode is set to Trend Line. 

Choose from the drop down list:

Linear - represent the relationship between variables as a straight line.

This is useful where data increases or decreases along a straight line, at a constant rate.

Quadratic - represent the relationship between variables as one curve in a line.

This is useful where data fluctuates up and then down, or vice versa.

Cubic - represent the relationship between variables as two curves in a line.

This is useful where data fluctuates up and down.

Harmonic - represent the relationship between variables with turning points. The chart usually resembles a "W" or "M" shape.

This is useful for predicting if a variable is going to reverse direction or continue on in the same pattern.

Image Removed

Gaussian -

Available when Mode is set to Expression.Refer to attributes using the syntax, _value.attributeName

This field allows values, e.g. 10, or expressions for calculating rescaling and rolling averages. The expression should return either a single value (fixed horizontal line), an array of 2 values (first and last), or an array of values matching the number of x values/categories.

The following Internal Variables can be used:

• _value returns an object  is a record of arrays
• _this returns  is an array of objectsrecords, e.g. _this.CompanyA + 10 increases each value for CompanyA by 10

Refer to attributes using the syntax, _value.attributeName

For an example chart setup using this option, see Creating a Custom Chart (Trends).