Create a Pareto Chart using Arcadia Data

While Arcadia does have a visual type of “Combo” that is a combination of a bar chart and line chart, it may not be obvious how to create a Pareto chart with Arcadia Data. It is possible!

By definition: " A Pareto chart, named after Vilfredo Pareto, is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line."

Here is an example created using Arcadia:

Using a Combo visual type, specify the dimension as what your bars will represent, in this example “channels”.

Specify your “Bar Measure” as what you would like in the bars. Specify a Descending sort on this measure.

The “Line Measure” is the tricky part. It combines some analytic functions, specifically “% of Total” and “Running Sum” to give the Pareto curve.

The final formula in my example is as follows:
(sum(sum(1)) over ( order by sum(1) desc rows between unbounded preceding and current row))/(sum(sum(1)) over ()) as ‘Pareto Line’

  • sum(1) represents the measure of the chart. In this case, we were just counting, but this could be replaced by any other measure

  • Be sure to specify ‘desc’ in the formula in order to get the line to generate in the correct direction. By default, it will be ascending, and will follow the same curve as the top of the bars.

  • Be sure to specify that the line goes on the Secondary Axis, and that the display format for the Pareto line is percentage.

2 Likes