Skip to main content

List report

Show grouped values as a list. Group by a field, sort and limit the groups, and add a total.

Written by Leo

Use a list for things like tasks per assignee, deals per stage, or tickets per priority.

A list report with open tasks per assignee and a total row

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

Add a list report

  1. Unlock the dashboard app (learn how →) and type /.

  2. Under Reports, select List.

  3. Choose a source. To change the settings, hover over the report, click ••• at its top right, and select Edit report.

Typing /list in an empty line of an unlocked dashboard app, selecting List under Reports, searching Stories under Select a database, and choosing it, after which the new list report shows Sprint 24 and Sprint 25 with their counts

Group the records

  • Group by: the field that creates the rows. You can use Single select and Multiple select fields, Status, Relation, Date, Member, Created on, Created by, Last edited on, and Last edited by fields, and Calculation fields that return a date.

  • Date by: appears for Date, Created on, and Last edited on fields and for Calculation fields that return a date. Choose a period such as Day, Month, or Year.

  • Status by: appears for a Status field. Group by Option or by Completion status.

The open report menu of the list report By assignee with Group by, Sort, Group limit, Hide empty groups, Include empty records, Group others, and Show total

Sort and limit

  • Sort: how to order the rows. The choices depend on the field, for example Alphabetical, Field order, Oldest first, Newest first, Value ascending, or Value descending.

  • Group limit: show only the top or bottom values, for example Top values 5 Groups.

Options

  • Hide empty groups: hides rows with no records. It's on by default.

  • Include empty records: includes records that have no value in the grouping field. In a list report, it's off by default.

  • Group others: puts all groups beyond the limit into one row called Others. In a list report, it's off by default.

  • Show total: adds a total row, shown as Total sum or Total count.

  • Show group icon: shows the group's icon next to its name.

Compare and format

A list report also supports Conditional formatting and Compare with a fixed Value, like a number report. Number format, decimal precision, unit, and color work the same way. Learn more about the number report →

FAQs

What is the difference between a list report and a view?

A view shows records. A list report shows calculated values per group. To see the records behind a value, select it. The Others row can't be selected.

Why is my list showing only five rows?

Group limit starts at Top 5. Open Edit report and choose a higher Group limit.

Can I add a list report to a published dashboard app?

Yes, reports on a published dashboard app load their data each time the page opens. Learn more about publishing →

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?