Hi there, plan to have two group aggregate value for a table group.
First value is count of the records in the particular group, and the other one is the sum of value of certain column.
initially I was planning to accomplish by adding a new column which include the record counting as a group. But it is not working if I further filter the records with the search function on the top.
your help is appreciated, thank you.
I suggest you to search if there is already a feature idea (which is most likely to be the case) or create your own
Perhaps I ask from a different view.
How can I get the number of records which is displayed in the current table list view?
By using COUNT as the group aggregate and a Group By column that all of the rows have in common (the same value for all of them)
User | Count |
---|---|
39 | |
32 | |
30 | |
17 | |
16 |