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.
Number and list reports with a
Numberfield:Count all,Count empty,Count not empty,Percent empty,Percent not empty,Sum,Average,Median,Minimum, andMaximum.Number and list reports with any other field:
Count all,Count empty,Count not empty,Percent empty, andPercent not empty.Charts with a
Numberfield:Count all,Count empty,Count not empty,Sum,Average,Median,Minimum, andMaximum.Charts with any other field:
Count all,Count empty, andCount not empty.Count allcounts records.Count emptyandCount not emptycount records where the field has no value or has a value.Percent emptyandPercent not emptyshow 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, andStatusfieldsRelationfieldsDatefields,Created on, andLast edited onMember,Created by, andLast edited byfieldsCalculationfields that return a date
Number reports have no grouping.
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,CompletedandNot 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 theGroup byfield. 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?
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?
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?
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?
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 →.
