Reports & dashboards

Turn your records into reports and dashboards

Build KPI cards, charts and tables from any of your data without SQL, or describe the report to the AI. Drill into the records behind a number, email reports on a schedule, and get alerted when a KPI crosses a line.

For founders, managers and finance teams who want answers without waiting on a spreadsheet.

Why it matters

Reporting that lives next to the work, not in a separate tool.

Decide from live numbers

Reports run on the same records your team works in, so there is no export-and-paste step to fall behind.

No analyst queue

Anyone with access can build a report by picking fields, or by describing it to the AI.

Numbers you can check

Click any bar or slice to see the exact records behind it, and open them in one click.

How it works

From question to shared dashboard in three steps.

  1. 1

    Pick your data

    Choose an entity, such as Orders or Tickets, and add related entities if you need their fields.

  2. 2

    Choose what to measure

    Group by a field or by date, pick metrics, add comparisons, goal lines and calculated fields. Or let the AI draft it.

  3. 3

    Share and deliver

    Add it to a dashboard, share it, schedule an email, set KPI alerts, or export it to CSV, Excel or PDF.

Try it: explore a sample report

Switch chart types, change the comparison, and click a bar to drill down.

Sales overview · Jan–Jun

Revenue

$147,700

+18%

Orders

659

+12%

Avg order

$224

-3%

Click a bar to drill down into the records behind it. The dashed line is a goal line.

See it in a real business

A short walkthrough that follows one business through the problem and the fix.

All videos

Automate 2:10

Scheduled reports, alerts and AI clean-up

Sparkle Pro, a cleaning company with 40 staff

Monday mornings used to mean building last week's numbers in a spreadsheet. Now the numbers are waiting for Rami.

  • A weekly report that runs itself, and a KPI alert with drill-down
  • Duplicate customers found by AI and merged in a few clicks
  • A site visit booked by typing in the calendar
  • A quote from a document template, and a deleted client restored
About Reports

More to watch

Build with AI

A sales team and its Monday pipeline question

AI Assist

Key capabilities

Everything you need to report on your business.

KPI cards, charts and tables

Number, bar, stacked bar, line, area, pie, donut and table sections. Combine several in one multi-section report.

AI report builder

Type “revenue by month with KPIs” and the AI fills in the sections, groupings and metrics for you to review.

Join related data

Bring in fields from related entities, for example orders with their customer and product.

Metrics and calculated fields

Sum, count, average, min, max, distinct count, conditional counts and percentages, plus your own formulas.

Comparisons and goals

Compare with the previous period or previous year, and draw goal lines on charts.

Drill-down

Click a chart element to list the matching records, then open one or jump to the filtered list.

Shared dashboards

Place reports on a dashboard, resize and reorder them, and switch the date range for every widget at once.

Scheduled email delivery

Email a report daily, weekly or monthly at the hour you choose, as a CSV or Excel attachment.

KPI alerts

Get notified when a KPI goes above or below a threshold, such as cash on hand or open tickets.

Exports

Download any report as CSV, Excel or PDF for the current date range.

Sharing you control

Keep a report private, share it with specific people, or publish it to everyone in the workspace.

Conditional formatting

Color table rows that need attention, for example overdue invoices in red.

Frequently asked questions

Short answers to what buyers usually ask.

Do I need to know SQL?

No. You choose an entity, how to group it (for example by month or by status) and what to measure (for example the sum of Amount). Or describe the report in plain English and the AI builds a first version.

Can a report combine data from more than one entity?

Yes. Add related entities to a report to use their fields, for example invoices with their customer's region.

Can reports be emailed automatically?

Yes. Schedule a report daily, weekly or monthly at a set hour, and it is emailed to the recipients you list as a CSV or Excel file.

How many dashboards can I create?

Dashboards depend on your plan: 3 on Starter, 25 on Pro and custom on Enterprise. Every plan starts with a 7-day free trial.

What's the difference between a report and a dashboard?

A report answers one question with KPI cards, charts and tables. A dashboard puts several reports side by side, so you can see the whole picture on one screen.

Related features

Scratchboard features that work together with this one.

Build your first dashboard today

Every plan starts with a 7-day free trial. Point it at your records and have a working dashboard in minutes.