Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have the expression rank(total rowno(total)) to get the number of rows in a chart.
But I have an issue with the performance of the expression because the data is too big.
Is there any alternative that can improve the performance and offers the same result?
Regards,
NoOfRows(total) ?
use the same in Script end... What actually you are looking for using this expression?
I dont want to add it in the script as I want it to dynamicaly calculate for every chart I use it.
I an using it to count the numbr of rows in the chart.
Any other ideas on how to better utilise the expression inside the chart?
RowNo(total) alone?
The best is you already using... may be wait for some other Gurus to reply...
Rank(Total RowNo(TOTAL))
RowNo(total) alone does not give the correct results inside the chart.
Is there any other way to take the max number of number of rows in a chart by using a different expression?
NoOfRows(total) ?
Hi tresesco thanks for the quick reply
This could be the correct answer. But I have not yet tested the performance of NoOfRows(total).
Out of your experiance which one do you think it performs best?
I have not tested with big data. Still, from general comprehension can say - it should be the one with single function (i.e - NoOfRows(total) ), because in the other one, qv has to operate on two functions -one on onother's output, which would be more costly in terms of performance.