Skip to main content

Reports

Add reports to a dashboard app to show records from a database app as a number, a list, or a chart. Choose a source, a view, and a field.

Written by Leo

A report is a block. It reads records from one database app and updates when those records change. You can use reports for many things, including:

  • Counting open tasks per assignee.

  • Showing revenue per month.

  • Listing the five biggest deals.

A dashboard app with four number reports next to a donut chart

Note:

Report types

  • Number shows one value, such as a count or a sum, optionally compared with another value. Learn more about the number report →

  • List shows groups with a value each, in a list. Learn more about the list report →

  • Pie chart shows the share of each group in the whole.

  • Donut chart works like a pie chart and can show the total in the middle.

  • Bar chart shows values per group as bars, optionally split into subgroups.

  • Line chart shows values per group as a line, often over time.

You can switch the type later with Type in the report settings.

Add a report

  1. Unlock the dashboard app. Learn how to lock and unlock apps →

  2. Type / or click the + icon in the left margin.

  3. Under Reports, select a type.

  4. Tape opens Select a database. Choose a database app from the list, or type in Search for a database… to find it.

Typing /num, selecting Number under Reports, and choosing the database app Tasks, after which the new number report shows 10

A report shows Data will show up here. when it has nothing to show, for example when no records match. A number report shows 0 instead.

Edit a report

  1. Hover over the report and click ••• at its top right. You can also click the ⋮⋮ block handle.

  2. Select Edit report.

The ••• menu of the report Tasks by status with Type, Source, View, Field, Calculation, Group by, and more

The settings depend on the report type. Every report has these:

  • Type: the report type.

  • Source: the database app the data comes from.

  • View: which records to include. Choose All records in this database or one of the views of the source, listed under Team views and Private views. A view works as a filter for the report.

  • Field: the field to calculate with.

  • Calculation: how to calculate, for example a count or a sum. Learn more about calculations →

  • Data access: whose data to include. Learn more →

Most reports also let you group the records, for example Group by a status or Date by month. Learn more about grouping →

Title, caption, and appearance

  • Enter a title at the top of the report, or leave Untitled. Select the icon next to the title to change it (Change icon).

  • To add a description below the report, hover over the report while the dashboard app is unlocked, select Caption, and type in Write a caption….

  • In the ••• menu, use Header to change the title size, Border to choose Solid, Light, Soft, or None, and Color to color the block.

  • To change the size, hover over the report while the dashboard app is unlocked and drag a handle: on the left or right edge for the width, at the bottom edge for the height, or at a bottom corner for both. To place reports side by side, drag them into columns. Learn more about columns →

Open the records behind a value

Select a value in a report to open the records it is made of in the source database app. The Others group can't be selected, and this isn't available on mobile devices.

Selecting the In progress segment of the donut chart Status of all tasks on a locked dashboard, which opens the Tasks app filtered to the 5 tasks in progress

View a report in full screen

Charts can open in Full screen. While the dashboard app is locked, hover over the chart and select the full screen icon next to its title. While it's unlocked, hover over the chart, select ••• (More actions), then Full screen. If you select a value in full screen, full screen closes and the records open. Number reports and list reports have no full screen.

If the page has more blocks that open in full screen, such as other charts, images, or embeds, switch between them without closing full screen: press the left or right arrow key, or select Back and Next. The counter, for example 2 of 5, shows where you are. Press esc to close full screen.

The block menu of a report with Full screen

FAQs

Can I get reports for only some members of my organization?

No, a plan applies to the whole organization. Paid plans are billed per member. Learn more about plans →

Can one report use several database apps?

No, a report has one Source. A number report can compare its value with data from another source. To show several database apps on one dashboard app, add one report for each.

Can I filter a report?

Yes, with View. Create a view with the filters you need in the source database app, then select it in the report.

Why does my report show "Data will show up here."?

The report has nothing to show: no records match its View, you have no access to the source database app and the report uses Default data access, or the data couldn't be loaded. Select Edit report and check Source, View, and Field.

Do reports update by themselves?

Yes, reports reload when records in their source change.

Can I add a chart to a view of a database app?

No. Charts are reports in a dashboard app. A report uses a view of the database app under View, so the records that view shows are the records the chart counts. Learn more about views →

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

Did this answer your question?