Overview

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. 

Image Modified

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

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

   , in the View Attributes section, click the 

   Insert excerpt
   _attributes_icon _attributes_icon nopanel true

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

Arrange the Data

Sort data into descending order using a Sort Order.

1. On the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , in the Data Retrieval Options section, click the 

   Insert excerpt
   _add_icon _add_icon nopanel true

    icon next to the Default Sort Order field
   1. Name: Enter a name for the sort order
   2. Sort Order Attributes: choose the integer attribute
      1. For the Direction, choose descending

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