5 Replies Latest reply: Oct 23, 2012 5:24 AM by Hans Maulwurf RSS

    Table Diagram Count Rows

      Hi everyone,

       

      i have a table diagram with 6 very complex dimensions.

       

      I want to show the number of rows (shown in the diagram) in diagram title.

       

      Can anyone help me?

        • Re: Table Diagram Count Rows
          Johannes Sunden

          Is there one dimension with a row of data for each dimension value?

          In that case, you can do a count of the dimension.

          • Re: Table Diagram Count Rows
            Kabilan Kumarasamy

            Hi,

             

            U can write the expression like bellow in the tittle text box.

             

            ='Diagram Tittle'& count(Your Dimension(Any one from your 6 Dimension))

             

            Hope This helps you

             

            Regards,

            Kabilan K.

            • Re: Table Diagram Count Rows

              The dimensions are complex expressions.

               

              One of this dimensions (dim1) looks like this:

               

              =aggr(if(count(if(startTime>= timestamp(date(today()-1)+'06:00:00'), if( startTime <= timestamp(date(today())+'06:00:00'),if(CompletionNr=-1,CompletionNr))))>0, count(if(startTime >= timestamp(date(today()-1)+'06:00:00'), if( startTime <= timestamp(date(today())+'06:00:00'),if(CompletionNr=-1,CompletionNr))))), KeyClientNrBackupsetID, TypDescription)

               

              If I use this dimension as count in the diagram title the result is different to the count of another dimension.

                • Re: Table Diagram Count Rows
                  Kabilan Kumarasamy

                  Hi,

                   

                  Count function Counts a 0 and null value also,

                   

                  For example,

                   

                  Myfield

                  12

                  13

                  14

                  15

                  null

                  0

                  16

                   

                  So here Count(Myfield)=7   not  5

                   

                  If u want 5 or u want to avoid the null and 0 values while count   use this ='Diagram Tittle  '&count({<Myfield-={'',0}>} Myfield)

                   

                  Hope this helps you.

                   

                  Regards,

                  Kabilan K.

                  • Re: Table Diagram Count Rows

                    Hi,

                     

                    my question is:

                     

                    I want to show the number of rows of the table diagram in the title.

                    Is it necessary to create a if-statement in combination of all complex dimensions of the diagram to get the number of rows? Or is it possible to get the (count of the) content easier?

                    I have 6 complex dimensions and the if-statement in the title would be very complex.