Versions Compared

Version Old Version 7 New Version Current
Changes made by

Zoe Baldwin

Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
namescreen
nopaneltrue

Overview

This feature is available in PhixFlow version 11.1+.

Use custom series to Use 

Insert excerpt
_custom_series
_custom_series
nopaneltrue
 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.

Insert excerpt
_property_toolbar
_property_toolbar
nopaneltrue

Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

FieldDescription
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
Algorithm
  • Trend Line
    • Choose this to display a drop down list of
calculations
    • 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 
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 Chart (Trends).

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

    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 -
set a chart line at
  •  shows the average value 
  • Minimum - shows the smallest value 
  • Median -
set a chart line at
  •  shows the middle value, when the data is ordered ascending
  • Maximum - shows the largest value 

  • Standard Deviation -

set a chart line to display how

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

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

  •  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 - set a chart line at the largest value 
  • Minimum - set a chart line at the smallest value 
  • Sum - set a chart line at the result of adding all values together
  • Cumulative Sum - set a trend line showing the running total of the data values


    • 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
    Image Added

    Sum for Single-Series Chart

    Image Added

    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.

    Image Added

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

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

    Image Added

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

    This is useful where data fluctuates up and down.

    Image Added

    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 Added


    Expression

    Available when Mode is set to Expression.

    Excerpt
    nameExpression

    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

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

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

    _this returns an array of records

    Code Block
    titleExample
    //increases each value for Company A by 10

_this.CompanyA + 10

    Refer to attributes using the syntax, _

    current

    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
    StyleChoose from dashed, dotted or solid.


    Insert excerpt
    _audit
    _audit
    nopaneltrue

    Live Search
    spaceKey@self
    additionalnone
    placeholderSearch all help pages
    typepage

    Panel
    borderColor#00374F
    titleColorwhite
    titleBGColor#00374F
    borderStylesolid
    titleSections on this page

    Table of Contents
    maxLevel3
    indent12px
    stylenone


    Learn More

    For links to all pages in this topic, see Creating Dashboards and Reports (Charts and Graphs).