Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
we have put if condition an an expression lets say for calculating values which are less that 25% . We are getting some rows in the straight table. But when I am trying to take count of rows in other text box somehow i am not able to get correct value. Can you please suggest what would be the correct expression and approach?
Something like this: count(aggr( if( ...something < 25%... ,1),Dim1,Dim2,...DimN)). Replace Dim1,Dim2,...DimN with the names of the dimensions in your straight chart.
I am getting values in a straight table and the count of rows i want in a different text box. Suppose in a straight table total no. of rows are 50 then in a text box i should get count as '50'. will that be possible with the above expression?
Something like this: count(aggr( if( ...something < 25%... ,1),Dim1,Dim2,...DimN)). Replace Dim1,Dim2,...DimN with the names of the dimensions in your straight chart.
Thanks a lot Gysbert. It worked. Just one more query, Suppose i have to get count by using dual condition like greater than 25% and less than 50% how should i use in the above expression?
Just replace the if statement with a new if statement that tests both conditions. If( x > 25% and x < 50%,1)
Hello Gysbert,
What if I have calculated dimension with an If statement also?
Regards,
Vishal
Can I use aggr() or IF as a Dim1 and Dim2 etc. in the aggr expression suggested by you?
Please help I am in a fix