Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created adhoc report , where user can select up to 4 dimensions & expressions from dimension , expression list boxes at a time.
once user will select dimension & expression from list boxes , table chart will show the data for those selections.
I want to capture how many rows is available in table so that user will come to know , how many rows is there in table.
please let me know how i can get the row count of table in text object according to selection of dimension & expression by user.
Use Statistic Box object:
One simple way to show the number of rows is to add an expression, Row Count, with a value of 1, and with a total Mode of Sum of Rows.
That's not in a text object, of course. I believe the expression for a text object is going to depend heavily on how you've implemented your adhoc report.
Hi,
You can also use the dynamic count function which will count the numbers of distinct values.
Lets assume that your Dimension Field (from where users are selecting the Dimension for chart) is _dimension.
Then you can use below expression in the Caption of chart to get the numbers of records.
=Count(Distinct $(=Concat(_dimension,'&')))
Regards,
Kaushik Solanki