Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add count for each group in tablebox?

Hi experts,

I would like to add count for each group in tablebox. I can get the count by using aggr function, but have no idea of how to display them. My sample project is attached. Please advise.

Thanks.

Longmatch

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

TableBox not supports expressions, you can use a Straight Table.

Create Straight Table.png

Add the dimensions and add the expression Count(HospitalAccountID).

Attached, I send your app with the changes.

Regards,

Ricardo

View solution in original post

2 Replies
Not applicable
Author

Hi,

TableBox not supports expressions, you can use a Straight Table.

Create Straight Table.png

Add the dimensions and add the expression Count(HospitalAccountID).

Attached, I send your app with the changes.

Regards,

Ricardo

Not applicable
Author

Thanks. It works fine!