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

# 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

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

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

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.