Overview

This feature is available in PhixFlow version 11.1+.

Use custom series to add quartile, trend, target and/or arbitrary lines to your charts in PhixFlow.

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

Expression: The expression will have access to the the data array. This will allow simple expressions such as 10, or more complex ones 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 Modified

Algorithm

Image Modified

Expression

Image Modified

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:

1. Click 

   Insert excerpt
   _table_list _table_list nopanel true

    

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

   Info
   This table can be downloaded from the PhixFlow learning centre

   
   

3. PhixFlow then asks how to display the data using:Image Modified
4. Click Line Chart. 
5. The attribute picker will then appear. Drag IntakeYear to X Attributes and Count() to Y Attributes. 

Image Modified

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

1. Right click on the line chart and Show view configuration
2. Open the attribute picker by clicking 

   Insert excerpt
   _attributes _attributes nopanel true

3. Drag the attribute Gender into the Series group
4. The IntakeYear is now grouped by gender.

Image Modified

Styling Lines

• set colour
• set dash style

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.