Tables: Average Data in a Column

Use this action to save the mean of the numbers in a data table column to a field.

Use case

A typical situation to use the Tables: Average Data in a Column action will be to quickly summarize the data in a column by getting a mean. For example, evaluating the average order size.

How to configure this action

This action will average values of integers and decimals and has specific behaviors for if there are strings or blank values in a column:

  • This action will ignore rows that have a blank value.
  • If the column contains all text, the mean returned will be 0.
  • If the column contains text mixed with numbers, the action will ignore rows with text and average the numerical values.

Fields for this action

  • Data table ID

    • Select a table from a list of all tables available on your team. The list only includes tables you have permission to view.
      • You can also reference a table stored in a field. Change the left hand drop-down to Use table via field then select from any field that is part of the process. Learn more.
      • If necessary, you can enter the Table ID directly. Change the left hand drop-down to Use table by ID then enter the ID manually. Learn more.
  • Column name

    • The display name of the new column header, in the regular Column Header format.
  • Output field name

    • Enter the name for the field in which the result should be saved.

What will this output?

The action will output a field with the mean of the column. The field name will depend on the Output field name set during configuration.

Get help with a problem or question

If something’s not working as expected, or you’re looking for suggestions, check through the options below.

The action is returning “0” as the average

This often happens when the column is a Text type field.

To prevent this, either rework the process so the field is an Integer or remove all non-numeric characters, for example 10,000 or $10000 or 10000 yen must be just 10000.

Why do some column names not work?

Enclose individual column names and values in quotation marks (""), if they contain special characters like commas, leading/trailing whitespace, and newlines. For example:

  • If the column name is $Weekly Report,,,, enter the column name as "$Weekly Report,,,", with quotation marks.
  • If you want to use the field reference {{tablecolumn}} to dynamically reference the column name, enter it as "{{tablecolumn}}"

If the column name contains a quotation mark, escape each quotation mark with quotation marks, for example: if the column name is "Column name", enter it as """Column name""".

Sorry about that. What was the most unhelpful part?

Thanks for your feedback

We update the Help Center daily, so expect changes soon.

Link Copied

Paste this URL anywhere to link straight to the section.

Need more help?

If you're signed in to Catalytic Community, you can ask other users a question. You'll be redirected to Community where you can add more info.