Creating a Pareto Chart
- Zoe Baldwin
Owned by Zoe Baldwin
Overview
This feature is available in PhixFlow version 11.1+.
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.
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.
- Create a bar chart, see Creating a Bar Chart
- Right-click the chart and click Show the View Configuration
Select the Attributes
Choose the attributes to display and how they will be displayed.
- On the Properties, in the View Attributes section, click the icon and drag the attributes required into the View Attributes section of the Properties
- Drag the integer attribute twice as one of these attributes will be used for the cumulative sum/percent
- Double-click on the attribute that represents the categories
- On the View Attribute tab, change its Role to Horizontal Axis Attribute
- Double-click on one of the integer attributes
- On the View Attribute tab, change its Role to Data Point
- Double-click on the second integer attribute
- On the View Attribute tab, change its Role to Cumulative Sum or Cumulative Percent
- Cumulative Percent: the running total percentage accumulated at each point in the data, ending in 100%.
- Cumulative Sum: the running total of the values.
- On the View Attribute tab, change its Role to Cumulative Sum or Cumulative Percent
Arrange the Data
Sort data into descending order using a Sort Order.
- On the Properties, in the Data Retrieval Options section, click the icon next to the Default Sort Order field
- Name: Enter a name for the sort order
- Sort Order Attributes: choose the integer attribute
- For the Direction, choose descending
For the Properties tab settings, see View Attribute.
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.