Pareto Select in Action

[#1]

Hi,

What is the Purpose of Pareto Select? How it can be used?

VJ

[#2]

This type of selection is used to select the top contributors to a measure, typically in line of a general 80/20 rule. For example, to find the top customers that contribute to 80% of the turnover, then Customer should be used as field, sum(Turnover) should be used as expression and 80 should be used as percentage.

[#3]

Hello mOngkz,

How would you make it so that only the LOWER 20% appear?

Cheers,

S.

[marcelo_7]

One possibility would be to select excluded afterwards.

[Anonymous]

One way of doing this is by selecting the 'complement' box within the Pareto Action in the properties of your button.

Just be careful with this one, based on your data structure, the complement might not exclude all values.

I had a scenario where my dimension was in weeks, and the 80% mark lied within a certain week.

Example: Pareto select of 80% yielded week 1-4

Pareto select of 20% on the same data yielded week 4-xx

Correctly calculating the data would yield that 20% was from week 5 and onward. 

[Anonymous]

Pareto select within a button action will select all records (based on your specified field) which add up to a predefined percentage of a calculated expression.

Example (as given above),

If you would like to determine the nr of customers who contribute to 80% of sales in your company, the you would use the Pareto Select with a percentage of 80%.

The syntax used in the action properties is a bit weird, it does not take in '=' for expressions and fields.

[Anonymous]

You could set it up as below:

Field: Customer

Expression: =Max(ALL Aggr(Sum(Turnover),Customer)) - Sum(Turnover)

Percentage: 20