Analytics: Data Table

You can add a Data Table in the analytics tab to show the app submission data in a neatly tabled form with rows and columns.

Click on the Design App. Go to the Configurations tab > Live Dashboard > click on Add Chart and select Data Table.

Editing the Data Table

Once you click on the Data Table option from the menu, a right panel for editing appears on the right side with a preview of the data table on the left side.

‍

Chart Builder

Chart Title

A chart title is the heading or the name of the data table.

‍

Aggregation

Aggregation means the total number of submissions in the app.

‍Aggregation consists of a list of specific functions:

Sum - Calculates and displays the sum or addition of numerical values of submissions. If the submissions do not contain a numerical value, then it will display 0.

Count - Total number of submissions

Average - Calculates and displays the average of numerical values of submissions. If the submissions do not contain a numerical value, then it will display 0.

Minimum - Displays the minimum numerical values of submissions. If the submissions do not contain a numerical value, then it will display 0.

Maximum - Displays the minimum numerical values of submissions. If the submissions do not contain a numerical value, then it will display 0.

Unique - Displays all unique submission data in a field. For multiple submissions of the same value, it will count it as 1.

Once you add an aggregation to your data table, the option to add additional aggregations will appear.

‍

Column Name

Column name is the heading of the column in the data table for the aggregation chosen.

‍

Dimensions

Dimensions are the columns in the data table that are the fields of the app.

Select the field from dimensions (the first dropdown) and if the field values contain numerical values, select ‘number’ for the next dropdown, else select it as ‘string’.

Once you add a dimension to your data table, the option to add additional dimensions will appear.

Missing Value

In case some of your submissions do not have any values in them for the selected column, you can give a value in the ‘missing value’ option to fill in the data table.

Apply Filters

Filter the submission based on certain criteria of other fields in your submission.

‍

Example

The below Marketing Activity app consists of 13 submissions. 

‍A data table will be configured for it.

‍

Aggregation - Count

Column Name - Count

Dimension - Type 

The 2nd dropdown is selected as ‘String’ as the column ‘Type’ is not a numerical value.

Click on save and the below output will be shown for the data table. It also shows the total count at the bottom. This is a data table with a single aggregation (Count).

‍

You can add more than one dimension in the data table corresponding to the fields in your Clappia app.

You can apply filters.

‍

You can also add more than one aggregation:

Example

Aggregation - Count

Click on the Add Aggregation button to have multiple aggregations in the data table.

Additional Aggregation - Unique

Field selected (below Unique aggregation) - Type

Dimension - Status

This is a data table with multiple aggregations (Count and Unique)

‍