Forum Discussion
how to use stacked chart
Hey jjmao ,
this is not how the 100% chart types work, the values you are using are considered forming the total, this means that the 1 who visited the store represents a third and not one of 2, meaning 50%.
For this reason, you have to create a measure that represents the remaining part of the group. From the sample you provided I created this simple measure:
the other part of the group = 1 - [% of group]If, I'm using both measures on the 100% bar chart it will look like this:
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
Super UserHey jjmao ,
this is not how the 100% chart types work, the values you are using are considered forming the total, this means that the 1 who visited the store represents a third and not one of 2, meaning 50%.
For this reason, you have to create a measure that represents the remaining part of the group. From the sample you provided I created this simple measure:
the other part of the group = 1 - [% of group] If, I'm using both measures on the 100% bar chart it will look like this:
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom