Versions Compared

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

Use layout categories to configure highlighting of an area that is a preferred parent, when you drag components from the palette onto a screen; see Component Categories and Preferred Parents for details

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

the

a name for the

layout category, which PhixFlow will add to the Layout Categories section of the repository.Drag layout categories from the repository into the Preferred Parent Categories section of components

custom series.

Right Axis

Enable this to display the custom series

' value

for the data on the right axis

, along with relevant increments

.

Mode

Choose from:

  • Algorithm
    • Choose this to display a drop down list of calculations
  • Percentile
: 

Percentiles are
    • This is a type of quantile that 
show
    • shows how a value (percentile) compares to other values
from
    • within the same
group
    • set of data
    • They indicate the value below which a given percentage of values in
a group
    • a set of data falls, e.g. the 50th percentile represents the point below which 50% of the data falls
, or if a exam score is at the 80th percentile, it means the candidate scored the same as or higher than 80% of other candidates in the same group
  • Algorithm - Drop down selection of algorithm/trend
  • Expression
Percentile

Available when Mode is set to Percentile. 

Enter a number between 0 and 100.

Image Removed

Standard Deviation - measure of
  • 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 - average value of a set of numbers
  • Median - middle value of a list of numbers when they are ordered from least to greatest
    • 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 - 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

    in a data set

    • are from the mean

    . Helps

    • 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


    • Sum -
    the largest value in a set of numbers or the highest point on a graph
  • Minimum - the smallest value in a set of numbers or the lowest point on a graph
  • Sum - the result of adding two or more numbers together
  • Cumulative Sum - the running total of a sequence of numbers
  • Cumulative Percent - the total percentage accumulated up to a certain point in a series. it reflects the cumulative contribution or impact of each percentage value as it progresses over time or through a particular set of data
    • Image Removed
    •  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.

    Image Removed

    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, _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
    slolid
    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).