Overview

This feature is available in PhixFlow version 11.1.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

For the Properties, see Custom Series.

Algorithm Lines

Algorithm lines 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 Removed

Creating Algorithm Lines

Pareto charts are used to identify the most significant factors among a set of variables. They are made up of a bar chart and a line chart, where the bars represent categories in descending order of frequency or importance, while the line represents the cumulative percentage or sum.

REPLACE IMAGE ONCE BUG FIXEDImage Added

Creating a Pareto Chart

Typically, pareto charts are made using two attributes - a string based attribute for the categories and an integer based attribute for the cumulative percentage or sum. 

Image Added

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

   Insert excerpt
   _view_show_config _view_show_config nopanel true

   In

Select the Attributes

Choose the attributes to display and how they will be displayed.

1. On the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , expand the Custom Series sectionClick  in the View Attributes section, click the 

   Insert excerpt
   _addattributes_icon _addattributes_icon nopanel true

    icon to create a new Custom Series
2. Name: Enter a name 
3. Right Axis: Enable this to display the custom series for the data on the right axis
4. Mode: Choose Algorithm
Algorithm: Choose from:
5. 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.

6. Mean - shows the average value

7. Minimum - shows the smallest value 
8. Median - shows the middle value, when the data is ordered ascending
9. Maximum - shows the largest value 
Standard Deviation - 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.

Sum - shows the result of adding all values togetherFor a multi-series chart, this will be the sum for each column of data, for example: 
Image RemovedFor a single-series chart, this will be the sum of all values, for example:
Image Removed
10. Colour: Choose a colour for the chart line from the colour picker
11. Style: Select a line style from dashed, dotted or solid

Image Removed

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 Removed

Creating Percentile Lines

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 Removed

Trend Lines

Trend lines represent the general direction in which data points are moving or trending over time. They help visualise patterns in data and can help make predictions about whether data will be increase or decrease over time. The trend lines available in PhixFlow are: Linear, Quadratic, Cubic and Gaussian.

Below is a bar chart showing how the quantity of different objects change month-on-month. The dashed pink line represents a Gaussian trend. Click on the image to enlarge it.

Image Removed

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_confignopaneltrueIn and drag the attributes required into the View Attributes section of the Properties
3. Drag the integer attribute twice as one of these attributes will be used for the cumulative sum/percent 
4. Double-click on the attribute that represents the categories
   1. On the View Attribute tab, change its Role to Horizontal Axis Attribute
5. Double-click on one of the integer attributes 
   1. On the View Attribute tab, change its Role to Data Point
6. Double-click on the second integer attribute 
   1. On the View Attribute tab, change its Role to Cumulative Sum or Cumulative Percent
      

      Insert excerpt
      View Attribute View Attribute name CumPercentCumSum nopanel true

Image Added

Arrange the Data

Sort data into descending order using a Sort Order.

1. Create a line or bar chart, see Creating a Line Chart or Creating a Bar Chart
Right-click the chart and click  Insert excerpt_view_show_config_view_show_confignopaneltrueIn the  Insert excerpt_property_settings_property_settingsnopaneltrue, expand the Custom Series sectionClick the  Insert excerpt_add_icon_add_iconnopaneltrue icon to create a new Custom Series
2. Name: Enter a name 
3. Right Axis: Enable this to display the custom series for the data on the right axis
4. Mode: Choose Expression
Expression: Enter an expression using Functions and/or Internal Variables
Insert excerptCustom SeriesCustom SeriesnameExpressionnopaneltrue
5. Colour: Choose a colour for the chart line from the colour picker
Style: Select a line style from dashed, dotted or solid
6. On the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , expand the Custom Series sectionClick  in the Data Retrieval Options section, click the 

   Insert excerpt
   _add_icon _add_icon nopanel true

    icon to create a new Custom Seriesnext to the Default Sort Order field
   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 Removed

         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 Removed

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

         This is useful where data fluctuates up and down.

         Image Removed

         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 Removed

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

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 Removed

Creating Expression Lines

1. 1. name for the sort order
   2. Sort Order Attributes: choose the integer attribute
      1. For the Direction, choose descendingImage Added

Image Added

For the

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.