Summarise columns

You can apply summarisations to each of the columns in the table. The available summarisations are Count, Sum, Average, Minimum, Maximum, and None.

Method 1: From the column header

  1. ClickTap the drop-down arrow in the column header where you want to apply a calculation.
  2. ClickTap the calculation that you want to use.

Method 2: From the Refine slider

  1. ClickTap the Calculate tab in the Refine slider.
  2. ClickTap the column head for which you want a calculation.
  3. ClickTap from the list of calculations.
  4. ClickTap Apply.
Note:
  • For all numeric columns, the following summarisations are available: None, Sum, Average, Minimum, and Maximum
  • For all string columns, the following summarisations are available: None, Count (number of rows)
  • For all date columns, the following summarisations are available: None, Count (number of rows)
  • For all Boolean columns, the following summarisations are available: None, Count