5 Replies Latest reply on Jun 18, 2018 8:12 AM by David Maning

    Histogram on Dimension

    Ishant Mete

      Hi All,

       

      I facing issues with the filtering on histogram which I've creted on dimension.

      Details I got :

      1. Business Problems around which the data is based on.

      2. Rules applied on set of records. (record id as primary key)

      3. Records are the ground level entity.

       

      Functionality I'm trying to achieve :

      Histogram showing number of records failing on group of rules. like 1 shows records failing for only one rule and 2 shows records failing for two rules and so on.

       

      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.

       

      need guidance to handle this scenario.

       

      Thanks in advance.

       

      - Ishant

        • 1. Re: Histogram on Dimension
          lei.chen.0

          Hello Ishant,

           

          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".

           

          Regards

          Lei

          • 2. Re: Histogram on Dimension
            Ishant Mete

            Hi Lei,

             

            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.

             

            Thanks,

            Ishant

            • 3. Re: Histogram on Dimension
              David Maning

              Hi,

               

              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.

              D

              • 4. Re: Histogram on Dimension
                Ishant Mete

                Hi David,

                 

                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".

                 

                - IshantCapture.PNG

                • 5. Re: Histogram on Dimension
                  David Maning

                  I suggest to use LOD in this case to avid filters.

                   

                  D