Experience Builder does not provide a statistics function in the Table widget. There are couple of walkarounds that may help achieve the function:
1. Add a Chart widget to calculate the statistics. Use the chart output data as the data source of the table sheets.
- Add a chart and select Statistics as Count
- Create a new sheet in the Table widget, and select Chart statistics output view
It will give you a table of counts from selected categories in the Chart widget. But the field name cannot be customized and it can only show one field count in each sheet.
2. Create data views with predefined filters and use Dynamic content in the Text widget.
- Go to the data you would like to calculate statistics and create separate data views
- Add Text widgets and connect to the data views
- Use Dynamic content to calculate the count
To make the layout pretty, you can use layout widgets like Card, Row/Column/Grid to organize your titles and count texts. Here is an example that I created using Row/Column widgets to organize the layout:
Shen Zhang