This feature is available in PhixFlow version 11.1+.
Use Custom Series to add quartile, trend, target and/or arbitrary lines to your charts in PhixFlow. See Creating a Custom 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:
Mean - plot a chart line at the average value
Median - plot a chart line at the middle value, when the data is ordered ascending
Standard Deviation - plot a chart line to display 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.
Maximum - plot a chart line at the largest value
Minimum - plot a chart line at the smallest value
Sum - plot a chart line at the result of adding all values together
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
Cumulative Percent - plot a trend line showing 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.
Value - plot a chart line at the result of adding each recordset's values together individually