Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there,
lets say I have a Value list with the values: A B and C. I want to show them and their corresponding sub processes (A1-A4, B1-B4, C1-C4) in a stapled bar chart.
So what I did was: For the bars I created the ValueList('A','B','C')
and then for every sub process i added bar lenghts. For the Process steps 1 (A1,B1,C1):
If (ValueList('A','B','C')= 'A' , A1,
IF(ValueList('A','B','C') = 'B',B1 ,
IF(ValueList('A','B','C')='C',C1 ) )
)
I did this for the other subprocesses and I got a nice stapled bar chart.
All well and good, as long as I do not want to have specific colors for the corresponding sub processes 1 to 4.
By a formula i can give each process ( A,B,C) a color:
But i want to colorize it by the subprocess steps:
Is there a way? I cannot use the standard colors and unfortunately i cannot change the standard colors- this maybe a workaround... This is so far already way too complicated by the way 😕
Thanks for the help !
I solved it by replacing the ValueListe for new Master Dimensions:
One Master-Dimension for the ValueListe ABC, and one Master-Dimension for the Processes.
Then I created MasterKPI's for the Processes with the content:
count(if(ProcessStep='1', Tasks)).
Then add the color to the Master-KPI and it works just fine :).
Olá, @BCFi
Você pode inserir suas mídias no item mestre, e insira para cada uma a cor que deseja.
Inserir a expressão e a cor:
Caso tenha ajudado, marque como solução e deixe um like
Grato!
Hey @MatheusC ,
i am using already Master Elements. But this wont work with value lists :-/.
If i would do it with Master Elements you would need to show me how to create this graph. Maybe you can share an example?
Thansk already !
Hey there,
I still could not do it. Can't anybody help ? Should I explain sth more?
Best regards!
I solved it by replacing the ValueListe for new Master Dimensions:
One Master-Dimension for the ValueListe ABC, and one Master-Dimension for the Processes.
Then I created MasterKPI's for the Processes with the content:
count(if(ProcessStep='1', Tasks)).
Then add the color to the Master-KPI and it works just fine :).