Skip to main content

Report calculations & grouping

Choose how a report calculates its values and how it groups records, including count, sum, average, date periods, and status grouping.

Written by Leo

Field and Calculation decide what a report measures. Group by decides how the results are split. Every report calculates a value. In number reports, there is one value. In lists and charts, there is one value per group.

Note: Reports and charts are only available on the Premium Plan. Learn more about plans →

Choose a field and a calculation

Hover over the report, click ••• at its top right, and select Edit report. Set Field, then Calculation. The options depend on the field and the report type.

Opening Edit report from the block menu and selecting Calculation with Count all, Count empty, and Count not empty

  • Number and list reports with a Number field: Count all, Count empty, Count not empty, Percent empty, Percent not empty, Sum, Average, Median, Minimum, and Maximum.

  • Number and list reports with any other field: Count all, Count empty, Count not empty, Percent empty, and Percent not empty.

  • Charts with a Number field: Count all, Count empty, Count not empty, Sum, Average, Median, Minimum, and Maximum.

  • Charts with any other field: Count all, Count empty, and Count not empty.

  • Count all counts records.

  • Count empty and Count not empty count records where the field has no value or has a value.

  • Percent empty and Percent not empty show the same as a percentage.

A Calculation field that returns a number counts as a Number field.

Group by a field

In lists and charts, Group by creates the groups. You can group by:

  • Single select, Multiple select, and Status fields

  • Relation fields

  • Date fields, Created on, and Last edited on

  • Member, Created by, and Last edited by fields

  • Calculation fields that return a date

Number reports have no grouping.

The report menu of the donut chart Tasks by status with Group by open, a search field, and the fields Assignee, Priority, Status, and Belongs to project, with Status selected

Date by

For date fields, Date by sets the period of each group: Day, Week, Month, Quarter, or Year. To compare the same period across years, use Day of week, Month of year, or Quarter of year. For example, "Month of year" puts all Januaries in one group.

Status by

For a Status field, Status by offers two ways:

  • Option: one group for each status option.

  • Completion status: two groups, Completed and Not Completed.

Subgroup by

In bar and line charts, Subgroup by splits each group again. It accepts the same field types as Group by. It isn't offered with Average, Median, Minimum, or Maximum, or while Group others is on. Learn more about charts →

Empty groups and records

  • Hide empty groups: removes groups without records. It's on by default.

  • Include empty records: includes records that have no value in the Group by field. It's on by default in charts and off by default in list reports. In charts, these records show as a group marked "empty".

FAQs

Can I group by a text field?

No, group by a select, status, relation, date, or member field instead.

Why are my groups in the wrong order?

Use Sort in Edit report. Learn more about sorting groups →

Can I get an average per group?

Yes, choose a Number field, set Calculation to Average, and set Group by.

Are there other report types?

Yes! A report can show records from a database app as a number, a list, or a chart. See every report type in Reports →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?