Could some one help to use the aggregate function count to get number of rows based on one particular column. For e.g something like below corresponding to sql.
select count(1),testcolumn from testtable group by testcolumn .
so i can get the records liks as below:
Were you able to resolve this query with the given solution or do you still need more help here? Do let us know.
you can do a query and then click on "group". You also check the box to Advanced parameters