Create slice group count table

[desmond_lee]

Hi All

How do I create a slice table that that has a expression unique COMBINE CODE column and count COMBINE CODE column.

[SkrOYC]

First, I have no idea how to do such a thing inside AppSheet Databases, it's a preview feature and I'm not very interested in it for the time being.
If it's something tied to AppSheet, you could use a Group by with that column and COUNT the number of records.

Control grouping - AppSheet Help

[desmond_lee]

Thanks buddy. One of the most difficult thing in appsheet is to group and count. This is the weakest point in appsheet. The deck or table is only good for view. If is create that then if you try to add a ref at the database area deck/table in view cannot be visible. Only table and slice is visible to ref function. Thanks