Versions Compared

Version Old Version 14 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 

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

    Tip
Mean - plot a chart line at the average

  • 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

    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
    •  shows 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
        • 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 Modified

      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.

      Image Modified

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

      This is useful where data fluctuates up and down.

      Image Modified

      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 - coming soon

      HTML Commenthiddentrue

      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


      Expression

      Available when Mode is set to Expression.

      Refer to attributes using the syntax, _value.attributeName

      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

      an object of arrays

      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

      objects

      records

      Code Block
      titleExample
      //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
      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).