100% Bar chart with Cyclical dimension

[triekong]

hi All,

i created 100%stacked bar charts using 100% Stacked Bar Graph.

it works great but i have a new requirement to add a cyclical dimension to the chart.

so my new dimensions are:

1. CategoryGroup: -Category0  -Category1 -Category2

2. SLA Breach

To be able to create the 100% chart, the formula used was : count((number))/Count(TOTAL <Category1> number)

i need the 'Category1' portion of this formula to change when the dimensions are changed, so that the bars will always be equal to 100% even when dimension has been changed.

Let me know if anyone has a workaround for this/ is it possible.

[sunny_talwar · Accepted solution]

Try this

Count(number)/Count(TOTAL <$(='[' & GetCurrentField(CategoryGroup) & ']')> number)