Ishant Mete wrote:
Problem in current design :
When filtered on any Business Problem, even though there is only one rule under that business problem but histo shows multiple groups since the underneath records are same where it should show only 1.
Please try this.
In worksheet "Sheet3", uncheck "Show Empty Rows".
Thanks for your response but the problem is with Histogram and not the sheet3.
like sheet3 is showing just one rule, the histogram should also show the failing record count against 1 sinnce after filtering its just one rule.
Hope I've explained my issue properly.
I don't quiet understand what you are looking for. However if you want to exclude filtering you just change its type and apply to selected worksheets. If you want to observe only one BP at once pls find worksheet attached.
Trust this helps.
Sample Workbook.twbx 50.6 KB
I want filter to be applied to all sheets.
I'm trying to build a histogram to show records failing per group of rules.
i.e. records failing for just one rule under label "1" then under label "2" there will be the count of records which are failing two rules and so on.
Somehow I managed to get the histogram done but then I expect it work when I apply the filter as well.
But when I apply the filter, the histogram is not working and even if there is only just 1 rule entry in rule sheet, the histogram shows records under multiple labels whereas it should show just label "1".
I suggest to use LOD in this case to avid filters.