Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Count(number)/Count(TOTAL <$(='[' & GetCurrentField(CategoryGroup) & ']')> number)
Try this
Count(number)/Count(TOTAL <$(='[' & GetCurrentField(CategoryGroup) & ']')> number)