Available when Mode is set to Algorithm. 

Choose from the drop down list:

• Cumulative Sum - shows the running total of the data values

• 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 - shows the middle value, when the data is ordered ascending
• Maximum - shows the largest value 

• Standard Deviation - 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.

  
  

• Sum - shows the result of adding all values together
  • 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

Sum for Single-Series Chart

For an example chart setup using this option, see Creating a Custom Series on a 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 Series on a 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 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.

Gaussian - represent the relationship between variables as a bell-shaped distribution.

This trend line is also known as normal distribution and is characterised by its symmetric shape around the mean.

This is useful for showing a symmetrical plot of data around its mean value, where the width of the curve is defined by the standard deviation.

Image Modified

Available when Mode is set to Expression.

//for the attribute, count, convert negative values to 0 and double the positive values

forEach(
		$item, _value.count, 
			if(
				$item <= 0, 0, $item*2
			)	
)

//increases each value for Company A by 10

_this.CompanyA + 10

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