Skip to main content

Use charts and reports to track progress

Turn your records into numbers and charts that update on their own. Build a dashboard app, pick the right report, and see three dashboards teams use.

Written by Leo
The Dashboard app of the Real Estate Investment workspace with number reports for fees, contracts, offers, the spread under contract, and new leads

Numbers and charts that update whenever your records change.

Every team wants to know how things are going: how many deals are open, which tasks are overdue, how much was spent this month. In Tape, you don't copy that into a spreadsheet. A dashboard app reads the records of your database apps and shows them as numbers and charts that update whenever the data changes.

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

How a dashboard app works

A dashboard app is a page with reports. Each report has a Source, the database app it reads from, and optionally a View to use only some records, such as only open deals. Change a record, and every report that uses it updates. Learn more about dashboard apps →

To create one, hover over a workspace in the sidebar, click +, select Blank app, and under Add new, choose Dashboard. Then type / and pick a report under Reports. Learn more about creating a dashboard app →

Selecting the plus button next to the Accounting workspace, choosing Blank app, then Dashboard, and the new empty dashboard app that opens

Create a dashboard app from the plus next to a workspace.

To change a report, hover over it, click ••• at its top right, and select Edit report. Choose the Field, the Calculation, such as Count all, Sum, or Average, and how to Group by. Learn more about report calculations →

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

Choose how a report calculates its number.

Choose the right report

  • Number for one key figure, such as open deals or this month's revenue. With Compare with, you show the change against a target or another source. Learn more about the number report →

  • List for ranked groups, such as the five biggest customers or open tasks per person. Learn more about the list report →

  • Pie chart and Donut chart for shares, such as tasks per status or deals per region. A donut chart can show the total in the middle.

  • Bar chart to compare groups, such as deals per stage. With Subgroup by, you split each bar, for example by owner, and spot bottlenecks.

  • Line chart for change over time, such as revenue per month. Group by a date field and set Date by to Month.

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

Type / to add a report to a dashboard app.

Combine reports into a dashboard

A dashboard app can hold reports from different database apps on one page. Arrange them in columns, add headings and text to explain them, and link to the database apps behind them with Link to app. A few ideas:

  • One page for several trackers, such as open tasks, overdue invoices, and new leads side by side.

  • One database seen in different ways, such as deals per stage, per owner, and per month.

  • A personal page per person, with Rules that show a block only for the Current user. Learn more about dashboard rules →

The Rules menu of a report block with a Show block rule and a Current user condition

Show a block only to the person who is viewing.

Three ways teams use dashboards

A goals dashboard for leadership

A bar chart of key results per team, grouped by status, shows which goals are at risk. A line chart of progress per month shows which teams are moving and which are stuck. Link goals and key results with a Relation field, and a Calculation field can work out the progress. Learn more about the calculation field →

A sales dashboard

A number report for the open pipeline, a bar chart of deals per stage split by owner, and a line chart of won deals per month. Every salesperson sees where the team stands without a weekly report.

A project overview

A donut chart of tasks per status, a bar chart of tasks per assignee, and a list of overdue tasks. The team sees the workload at a glance and knows where to help. Learn more about the status field →

The Project overview dashboard app with a donut chart of tasks by status and a bar chart of tasks by assignee

A project overview shows the workload at a glance.

Bring in data from other tools

Some numbers live outside Tape. With an Embed block, you place a chart or a report from another tool next to your Tape reports. Learn more about the embed block →

An embed block on a dashboard showing a PDF quarterly report of Acme Inc.

Place a report from another tool next to your Tape reports.

Learn more

FAQs

Do reports update on their own?

Yes. Reports read the records live. When someone changes a record, the reports that use it update. Learn more about reports →

Can a report show only some records?

Yes. Choose a View of the source database that filters the records, for example only open deals. Learn more about filters →

Can different people see different reports?

Yes. Add Rules to a block, so it shows only for certain people, groups, or devices. A rule only hides the block, it doesn't change what people are allowed to open. Learn more about dashboard rules →

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

Did this answer your question?