Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe use a calculated dimension like
=Aggr( Floor(Sum(Value),.1) , Employee)
and a single expression
=Count(DISTINCT Employee)
Maybe use a calculated dimension like
=Aggr( Floor(Sum(Value),.1) , Employee)
and a single expression
=Count(DISTINCT Employee)
that worked llike a charm
you are a god and lifesaver!!
thank you very much!!