You can use this widget to view the app summary data as a table. For example, you can see the sales volume of each manager over the selected period. You can sort and filter the results as you see fit.
To configure the widget, drag it to the canvas or click +Widget. Enter the settings in the pop-up window.
- Select the app to create a table report. For example, Contracts.
- Specify the following:
- Displayed fields. Select the app fields to be displayed as columns.
- Filter fields. Select the app properties to use as a report filter.
- Aggregation fields. This field automatically calculates and shows the sum of all values in the column. You can only select the fields you added in the previous step. Note that the sum is calculated only for Money and Number data types.
After you save the settings, you can see the table draft in the modeling field. You can edit the table by clicking on the gear icon.
To finish the configuration, click Save and Publish.
You can configure the report visibility. Click the icon near the page name and select the Page visibility menu item.
In the window that opens, specify the user group, Administrators, for example. The table will be visible to them only.