Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to have two bars (stacked) which show two states of a certain dimension. I tried the following, but it seems that the expression don't take the current filtering into account:
Count( {<State={'Done'}>} ID)
Count( {<State={'Open'}>} ID)
Is there something which I can improve to only count the current selection (e. g. if State = Open no bar with State=Done shall be shown)
Ich konnte so ein leeres Chart auf nur zwei Arten nachstellen:
Überprüf am besten beides nochmal.
Theoretisch könnte es auch ein Problem im Datenmodell geben, dass alle Werte im Versions-Feld keine IDs für die ausgewählten States haben.
If you don't have a primary "Stack" dimension, use this instead to generate an "empty" dimension:
=' '
Add the State field as the secondary "Bars" dimension.
If you have more than the two States, use this measure:
Count({<State -= E({<State = {'Done', 'Open'}>})>} ID)
Hi, I didn't get this. My dimension is SoftwareVersion. And I have two "Kennzahlen" (don't know the english word) which I want to show as stacked bars:
Count( {<State={'Done'}>} ID)
Count( {<State={'Open'}>} ID)
You want me to define an empty dimension like =' ' but my dimension is SoftwareVersion
We just need any dimension as a first/group dimension so we can use State as the dimension for the stack-segments.
If you have a dimension, use it. The expression works regardless:
Hi, I have done it now in this way, but the graph shows literally nothing although the axis description looks similar to yours.
Ich konnte so ein leeres Chart auf nur zwei Arten nachstellen:
Überprüf am besten beides nochmal.
Theoretisch könnte es auch ein Problem im Datenmodell geben, dass alle Werte im Versions-Feld keine IDs für die ausgewählten States haben.
Got it, you are richt, the values in the Set Analysis statement were wrong. Perfect. Thank you so much. Just a last question: is it possible to manage the colors of the shown states?
Kind of. You can change the colors but lose the legend: