Pareto diagram

[#1]

Hi,

I am looking for the solution to build Pareto diagram (link, how it should look is HERE).

So far I have created combo chart with split axis, which looks like pareto diagram...

But the distance between the upper and lower graph is too great - is it possible to change the distance between them?

Does anyone have any other solutions for drawing pareto graph?

Kind regards,

Miha

[martin59]

Hi,

Have you tryed to deactivate the "split axis" option and keep your 2 axis?

[#3]

Hi,

If I remove split axis, this is the situation:

The problem is that the second measure is in percentage, and the first is in million €, also I need line graph above the bar chart...

Kind regards,

Miha

[martin59]

Right,

You have to fix you max value, send me your expressions and I'll help you 😉

[#5]

The situation is the following:

1. expression is SUM(Sales) - no accumulation

2. expression is SUM(Sales) / SUM(total Sales) - FULL ACCUMULATION, percentage

I have tried with bar offset, but was unable to do any good 🙂

thanks,

Miha

[martin59 · Accepted solution]

right,

You have to do that :

1. For the first expression : Fix the static max value of your axe with this expression :

Max(aggr(sum(Sales),Dimension))

2. For second expression

Static min = Max(aggr(sum(Sales,Dimension))/sum(Sales)

Static max = 1

3. Adjust your Numbers format settings

Is that helps you ?

[Or]

I have a different take on creating a Pareto chart - created using a guide for ABC charts posted in one of the QV blogs a few months back (Sorry, I forget which, so I can't credit the author). This uses one expression for the bars, one identical but cumulative expression for the line, and three more for the standard percentages - 80, 95, and 100 (these can be modified using parameters). Unlike yours, it doesn't display specific percentages - if you need that part, you'll have to look elsewhere for a solution.

Hope this helps.

[#8]

Martin,

This is the thing I was looking for, yes 🙂

Thank you both,
Miha