Pareto with 2 expressions

[igorgois_]

I have the following model:

FACT:

LOAD * inline [

Employee,KPI,Value

1,A,0.2

1,B,0.3

1,C,0.15

2,A,0.5

2,B,0.1

2,C,0.1

2,D,0.3

3,A,0.8

3,D,0.1

4,B,0.3

4,C,0.3

];

Lets call "final kpi" as the sum of each kpi value. Its range is from 0 to 100% per each employee

I would like a pareto chart where:

X axis (the final kpi range): 0, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90% and 100%

Y axis: accumulated number of emploees that have the "final kpi" between these ranges

I tried multiples aggr and auxiliar dimensions, but without success.

Ps: I cant use the script to group the final kpi

Thanks in advance

[swuehl · Accepted solution]

Maybe use a calculated dimension like

=Aggr( Floor(Sum(Value),.1) , Employee)

and a single expression

=Count(DISTINCT Employee)

[igorgois_]

that worked llike a charm

you are a god and lifesaver!!

thank you very much!!