Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Is there one dimension with a row of data for each dimension value?
In that case, you can do a count of the dimension.
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.
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.
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.
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.