Overview

This feature is available in PhixFlow version 11.1+.

This page will show you how to add custom series to

any PhixFlow chart such as quartile, trend, target and/or arbitrary lines. 

There are 4 types (modes) of custom series:

• Algorithm
• Percentile
• Trend Line
• Expression

Algorithm Lines

Algorithm lines

This page will show you how to add data as line chart to any screen. It will go through a worked example creating a line chart to display the number of students across intake years in a local school.

possible to create Custom Series on charts, which include fixed values, percentile, other statistical functions and expressions.

• custom series
  • name
  • axis
  • line colour
  • line style
  • line smoothing
  • mode
    • Percentile - A number entry 0-100
    • Trend - Drop down selection of algorithm
    • Expression - a jep expression

When a single series exists on the selected axis the data points can be used as the data array. When multiple series are present then the array is the sum of the data points at each x point/category on that axis will be calculated

Percentile: The specified percentile function will be calculated over the data array. This will produce a single horizontal line that should be plotted the full width of the graph area.

Trend: The specified trend algorithm will be calculated over the data array, this will return a new data array with the point of the trend lines. An appropriate library should be found with a selection of trend algorithms

involve applying mathematical formulas or algorithms to chart data. The lines can help identify trends, make predictions or highlight patterns in the data. The chosen algorithm will be calculated using values from each column of data.

Below is a line chart showing how the quantity of different objects changes year-on year from 2001 to 2014. The teal line represents the mean value for each horizontal axis attribute (year). The yellow line represents the cumulative percent. Click on the image to enlarge it.

Image Added

Creating Algorithm Lines

Image Added

Percentile Lines

Percentile lines are a type of quantile showing how a value 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 is represented below the point at which 50% of the data falls.

Below is a line chart showing how the quantity of different objects change for each quarter of the year 2015 to 2016. The dashed yellow line represents the 30th percentile, while the dashed purple line represents the 60th percentile. Click on the image to enlarge it.

Image Added

Creating Percentile Lines

1. Create a line or bar chart, see Creating a Line Chart or Creating a Bar Chart
2. Right-click the chart and click 

   Insert excerpt
   _view_show_config _view_show_config nopanel true

3. In the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , expand the Custom Series section
4. Click the 

   Insert excerpt
   _add_icon _add_icon nopanel true

    icon to create a new Custom Series
   1. Name: Enter a name 
   2. Right Axis: Enable this to display the custom series for the data on the right axis
   3. Mode: Choose Percentile
   4. Percentile: Enter a number between 1 and 100
   5. Colour: Choose a colour for the chart line from the colour picker
   6. Style: Select a line style from dashed, dotted or solid

Image Added

Trend Lines

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 then down, or vice versa.Cubic - represent the relationship between variables as two curves in a line.This is useful where data fluctuates up and down.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

Creating Trend Lines

1. Create a line or bar chart, see Creating a Line Chart or Creating a Bar Chart
2. Right-click the chart and click 

   Insert excerpt
   _view_show_config _view_show_config nopanel true

3. In the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , expand the Custom Series section
4. Click the 

   Insert excerpt
   _add_icon _add_icon nopanel true

    icon to create a new Custom Series
   1. Name: Enter a name 
   2. Right Axis: Enable this to display the custom series for the data on the right axis
   3. Mode: Choose Trend Line
   4. Trend Line: Choose from:

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

1. 1. Colour: Choose a colour for the chart line from the colour picker
   2. Style: Select a line style from dashed, dotted or solid

Expression

Create bespoke chart lines using the Expression editor, which has access to the data in each recordset as a data array. Expressions can be used for simple expressions, e.g. 10, or more complex expressions, such as 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

Jep functions should be added to expose the percentile and trend algorithms.

Percentile

Image Removed

Algorithm

Image Removed

Expression

Image Removed

Creating Quartile Lines 

(Upper/Lower control lines)

There are 3 types of line charts

• Line Chart (category)
• Line Chart (numeric)
• Line Chart (time)

To change the type of line chart

1. Right click on a chart and Show the view configuration
2. Open the Basics section
3. Select Line Chart (category), Line Chart (numeric) or Line Chart (time) under Display Type

Creating Trends Lines

A teacher wants to display the number of students per intake year as a line chart. To add a line chart:

Drag and drop the desired table onto the screen. In this instance, the School_Students table is dragged onto the screen.

PhixFlow then asks how to display the data using:Image Removed

Image Removed

Creating Target (Arbitrary) Lines

Line Charts can display multiple series on the same graph. For example, the teacher might want to show the proportion of students of each gender on their line chart. To do this

Image Removed

Styling Lines

Below is a line chart showing how the value of different objects changes year-on-year. The expression, represented by the dotted blue line, converts negative values for the attribute, Object B, to 0 and doubles the positive values. Click on the image to enlarge it.

Image Added

Creating Expression Lines

1. Create a line or bar chart, see Creating a Line Chart or Creating a Bar Chart
2. Right-click the chart and click 

   Insert excerpt
   _view_show_config _view_show_config nopanel true

3. In the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , expand the Custom Series section
4. Click the 

   Insert excerpt
   _add_icon _add_icon nopanel true

    icon to create a new Custom Series
   1. Name: Enter a name 
   2. Right Axis: Enable this to display the custom series for the data on the right axis
   3. Mode: Choose Expression
   4. Expression: Enter an expression using Functions and/or Internal Variables
      

      Insert excerpt
      Custom Series Custom Series name Expression nopanel true

1. 1. Colour: Choose a colour for the chart line from the colour picker
   2. Style: Select a line style from dashed, dotted or solid

More Information

• Filtering and Sorting Grids and Charts
• Formatting and Styling Grids and Charts
• Using Relational Views
• Actions on Grids and Charts
• For a complete list of view properties and their functions, see View.