Overview

This feature is available in PhixFlow version 11.1.1+.

Use Custom Series to add quartile, trend, target and/or arbitrary lines to your charts in PhixFlow. See Creating a Custom Series on a Chart (Trends) for worked examples.

Property Pane Toolbar

For information about the toolbar options, see the Common Properties page, Toolbars and Controls section.

Properties Tab

Parent Details

If this item is within or belongs to another, its parent name is shown here. See the Parent Details section on the Common Properties page for more details.

Basic Settings

Field	Description
Name	Enter a name for the custom series.
Right Axis	Enable this to display the custom series for the data on the right axis.
Mode	Choose from: Algorithm Choose this to display a drop down list of calculations Percentile This is a type of quantile that shows how a value (percentile) compares to other values within the same set of data They indicate the value below which a given percentage of values in a set of data falls, e.g. the 50th percentile represents the point below which 50% of the data falls Trend Line Choose this to display a drop down list of trend lines which depict the general direction in which data points are moving or trending over time Expression Choose this to display the Expression editor
Algorithm	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 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 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).
Percentile	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).
Trend Line	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.
Expression	Available when Mode is set to Expression.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 a record of arrays Example //for the attribute, count, convert negative values to 0 and double the positive values forEach( $item, _value.count, if( $item <= 0, 0, $item2 ) ) `_this` returns an array of records Example* //increases each value for Company A by 10 _this.CompanyA + 10 Refer to attributes using the syntax, `_value.attributeName` For an example chart setup using this option, see Creating a Custom Series on a Chart (Trends).
Colour	Choose a colour from the colour picker Set the value in Hexadecimal format Set the RGB value
Style	Choose from dashed, dotted or solid.

Browser not supported