Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft

Output the

total

Total column

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

  • Sum
  • Average
  • Multiplication
  • 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.the Total column field and choose the required operation type.
  5. Once the operation type is selected, the Total column title field becomes visible - you may assign your custom name for the total column.
    The default name corresponds to the chosen operation type.
  6. Save the macro and the page.

To rename the Total column:

Locate

Info

Please note that on Data Center in the app versions older than 12.1.2 the Total column

title field.Enter the name you want for the

field was called Operation type for Total column.

Save the macro and the page

Other steps remain the same.

Handy Carousel

Image AddedImage Removed

Image AddedImage Added

Image RemovedImage Added


Output

totals for columns

the Total row

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

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

To enable the totals for a columnTotal row 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. Click Count totals for columns Set total row.
  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 Locate the Total row title field and assign your custom name for the total row if required.
    The default name for the Total row is "Total".
  3. Save the macro and the page.

Info

Please note that on Data Center in the app versions older than 12.1.2 the Set total row option was called Count totals for columns. Other steps remain the same.

Handy Carousel

Image Added

Image Added

Image RemovedImage Added

Image RemovedImage Added


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.
Info

If your table contains decimal numbers, you may need to specify the correct decimal separator on the Filtration tab.

Handy Carousel



Learn how to perform complex calculations and aggregate table data:

Table Excerpt
namehome
Section
Column
width170px

How to use Pivot Table macroImage Added

Column
width50%

Create a pivot table from your table, calculate and aggregate data

Children Display
pageHow to use Pivot Table macro
first3

Column
width250px

How to use Table Transformer macroImage Added

Column
width50%

Merge multiple tables, perform complex calculations and custom transformations

Children Display
pageHow to use Table Transformer macro
first4