Versions Compared

Version Old Version 10 New Version 11
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 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:

  • 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

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

    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

For an example chart setup using this option, see Creating a Custom 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 Chart (Trends).

Trend Line

Available when Mode is set to Trend Line. 

Choose from the drop down list:

Column


Section

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.


Section

Image Added



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 and down.

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

This is useful where data fluctuates up and down.

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.

Gaussian - coming soon


HTML Comment
hiddentrue

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.



HTML Comment
hiddentrue



Expression

Available when Mode is set to Expression.

Refer to attributes using the syntax, _value.attributeName

The following Internal Variables can be used:

  • _value returns an object of arrays
  • _this returns an array of objects

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