416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
Dashboard v5.5

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Pareto Chart Add-on

Hide navigation
RSS
Modified on Wed, 02 Dec 2015 02:54 PM
Click to return to: Documentation | Dundas Dashboard Add-ons


Go to the Dundas Dashboard Add-ons page for instructions on downloading and installing this add-on.

Overview

The Pareto chart is named after Italian sociologist, economist and philosopher Vilfredo Federico Damaso Pareto. It contains both a bar chart and a line graph where individual values are represented in descending order by bars, and a cumulative percentage is represented by the line. It allows readers to quickly identify the most important of a number of factors, causes or defects. The percentage line can help to identify how much the top N factors contribute to the total up to each point.

A Pareto chart.

A Pareto chart.


A Pareto chart with two series and a legend.

A Pareto chart with two series and a legend.

General usage

The Pareto Chart add-on works like other charts:

  1. Add a Pareto Chart to your dashboard in the Dashboard Designer.
  2. Drop a KPI or dataset onto the Pareto Chart.

Each series of data added to the pareto chart will be stacked on top of the previous as a stacked bar chart. The cumulative percentage line is calculated using the total of each stack.

The cumulative percentage line is optional. To display only the bars or stacked bars in descending order, hide the cumulative percentage series:

  1. Find the Series property of the chart and click its ellipsis button.
  2. Select the Cumulative Percentage series on the left.
  3. Find the Visibility property and set it to Collapsed.

When to use Pareto charts

Pareto charts are typically used to prioritize competing or conflicting “problems,” so that resources are allocated to the most significant areas. In general, they can be used to determine which of several classifications have the most “count” or cost associated with them. For instance, the number of people using the various ATM's vs. each of the indoor teller locations, or the profit generated from each of twenty product lines. The important limitations are that the data must be in terms of either counts or costs. The data cannot be in terms that can't be added, such as percent yields or error rates.

Properties


There is an additional property on the Pareto chart:

ImageImageProperty Name [Script Name]TypeDescription
Auto-Adjust Y Axis [IsYAxisAutoAdjusted]boolDetermines if the scale of the quantity axis automatically adjusts to match up the heights of the quantities with the cumulative percentages. If False, the cumulative percentage line may overlap with the bars. The default is True.

Release history

  • This add-on was first released with Dundas Dashboard 2.0.0.
  • Support for multiple series, an automatically-adjusting Y axis, and updated defaults were added to the version released with Dundas Dashboard 3.0.0.

Related topics


Click to return to: Documentation | Dundas Dashboard Add-ons

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2016 Dundas Data Visualization, Inc.