Create Data Tables in Clappia Analytics

You can add a Data Table in the analytics tab to show the app’s submission data in a neatly formatted table with rows and columns.

Click on “Design App”. Go to the Analytics 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, an editing panel appears on the right with a preview of the data table on the left.

‍Chart Title

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

‍

Aggregation

Aggregation refers to the function applied to a selected field in the data table, such as Sum, Average, Minimum, Maximum, Unique, or Count (total number of submissions), depending on the chosen option.

‍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 value of submissions. If the submissions do not contain a numerical value, then it will display 0.

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

Unique - Returns the count of distinct values in a field. If the same value appears in multiple submissions, it is counted only once.

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

Dimension is the column in the data table that corresponds to a field in the app.

Select a field under Dimension (the first dropdown). If it contains numeric values, choose Number; otherwise choose 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 1

The below Marketing Activity app consists of 13 submissions. 

A data table can 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 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 2

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)