Skip to main content

Building a Custom Report

How to build, save and share your own report with Report builder, by copying a dashboard, or by asking AI Assist. Requires Tern Pro.

J
Written by Jack Bradmiller-Feld

Build a table or chart that answers your own question, save it, and share it with your team. Everything here requires Tern Pro.

Note: Check Reporting → Browse or Where to Find It in Reporting first. Tern may already have a report that answers your question.

Building a Report in Report Builder

The example below finds which suppliers still owe your agency commission.

  1. Pick your data. Go to Reporting → Report builder and click the data source in the top left. Choose Your bookings for your own bookings. Agency owners and admins can also choose Agency bookings for everyone's bookings. Click Select.

  2. Tick the columns you want. Search the column list and tick each box. Each column you pick appears in the search bar.

  3. Filter a column. Hover a column, like Commission Status, and click its funnel. Tick the values you want, like overdue and partial, and click Apply.

  4. Run it. Click Go. Click a column header to sort.

  5. Save it. Click ··· and Save. Give it a name you'll find again, and click Save answer.

  6. Switch to a chart (optional). Use the table and chart icons. The panel on the right holds chart settings, like labels and colors.

Why Your Rows Turned Into Totals

Report builder makes one row for each combination of labels (like Supplier Name or Advisor) and dates (like Booking Date monthly). Numbers (like Gross Sales or Expected Commission) are added up within each row. That's why their headers say "Total."

To see every booking on its own row, add Booking ID. Add Booking Name to tell them apart.

Starting From a Dashboard

Every chart on Tern's dashboards can be the start of your own report.

  1. Open a dashboard. Go to Reporting → All reports → Dashboards and open one, like Agency sales and expected commission.

  2. Copy a chart. Click ··· on any chart, then Make a copy.

  3. Change your copy. It opens in the same builder. Add or remove columns, click Go, then save it.

Asking AI Assist

AI Assist builds the same kind of report from a question.

  1. Ask your question. Go to Reporting → AI Assist and ask in plain English. Say whose data you want ("my" for yours, "our agency" for everyone's), what to measure, and the time period.

  2. Save it or add it to a dashboard. Save keeps it in Saved reports. Add to dashboard puts it on one of your dashboards.

Finding and Sharing Your Reports

Go to Reporting → All reports → Saved reports to find everything you've saved, newest first.

To share a report, open it and click the share icon. Pick who can open it, then click Share:

  • Your agency's name (like "Duck Travel"): everyone in your agency.

  • Your agency's name plus "admins" (like "Duck Travel admins"): only your agency's owners and admins. Only owners and admins see this option.

You can't share with one person at a time. Sharing is available when your agency has an owner on Tern.

Note: Everyone who opens a shared report sees it through their own access. On "Your" data, each advisor sees only their own numbers. On "Agency" data, owners and admins see everyone's, and agents and collaborators see "No data found." To give advisors their own numbers and admins everyone's, save one version on each.

Note: Someone who becomes an admin can open reports shared with admins the next time they open Reporting.

Checking Your Work

Before you trust a number:

  • Look at rows before totals. Add Booking ID and a few columns until you can see exactly what's in and what's out.

  • Read the filters. Check the search bar and filter chips. "First 1,000 rows" under a table means it's cut off.

  • Check whose data. Report builder can reopen on your own data, so "our" numbers quietly become "my" numbers.

  • Check which date. "This year" can mean Booking Date, Travel Start Date or Expected Commission Date.

  • Watch for blank rows and duplicates. A "–" row, or one supplier listed two ways, can hide real money.

  • Compare with something you know. A booking you know, a dashboard total, or the same question asked in AI Assist.

Related Articles

Did this answer your question?