Calculations in tables

Output the total column

The app allows you to output the Total column. The following operations are available:

• Average
• Min
• Max
• Sum
• Multiplication

To enable the Total column for the table:

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Calculations tab.
4. Select the Operation type for the Total column.
5. Save the macro and the page.

To rename the Total column:

1. Locate the Total column title field.
2. Enter the name you want for the Total column.
3. Save the macro and the page.

Output totals for columns

The app allows you to count totals for specific columns in your table. The following operations are available:

• Sum
• Average
• Multiplication
• Min
• Max
• Count
• Count not empty

To enable the totals for a column:

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Calculations tab.
4. Click Count totals for columns.
5. Select the operation type for specific columns.
6. Save the macro and the page.

To rename the Total row:

1. Locate the Total row title field.
2. Enter the name you want for the Total row.
3. Save the macro and the page.

Output sparkline charts within tables

The app allows you to embed sparkline charts into the table column. Sparkline charts allow you to quickly visualize your data sets and see the data movements at once.

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Table View tab.
4. Locate the Sparkline charts slider and tick it.
5. Specify the appropriate name for the column outputting sparkline charts.
6. Click Save.
7. Once you save the page, you will see sparkline charts in a new table column.