topic Re: Pareto with 2 expressions in App Development

Pareto with 2 expressions

igorgois_ — Sat, 13 Oct 2018 15:02:18 GMT

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 — Sat, 13 Oct 2018 16:37:58 GMT

Maybe use a calculated dimension like

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

and a single expression

=Count(DISTINCT Employee)

igorgois_ — Sun, 14 Oct 2018 15:12:17 GMT

that worked llike a charm

you are a god and lifesaver!!

thank you very much!!