Analytics & Reports

Turn your live workspace data into reports: pages of tables, charts and headline numbers, built from SQL queries or from plain-English questions.

Analytics & Reports answers questions about your business from your live data. A report is a page of widgets. A widget is a query drawn as a table, a chart or a headline number. You can write queries in SQL, have AI write them from a plain-English description, save the ones you reuse, and even query other databases alongside your workspace.

The Reports page with report cards

What you can do

  • Build a report page — name it, add widgets, arrange them. Create a report
  • Choose what a widget shows — chart, table, headline number, note, form or button. Widgets
  • Pick the right chart — stacked and 100% bars, area, bar + line, funnel, pivot table, gauge and an India state map. Chart types
  • Arrange the page — sections, rows, widths and drag-and-drop. Arrange a report
  • Undo a bad edit — preview and restore earlier versions of a report. Report history
  • Send a report on a schedule — by email or WhatsApp, daily, weekly or monthly. Schedule a report
  • Get told when a number crosses a line — for example cash below ₹2,00,000. Alerts
  • Share outside the workspace — a read-only link or embed with an expiry and password. Share a report
  • Print, PDF and images — print or save as PDF, download charts as PNG. Print or download
  • Find your reports fast — star favourites, pick a home page, file by tags. Favourites, home page and tags
  • Write and run queries — the full-screen workspace with AI help, results, CSV and Sheets export. Query workspace
  • Know the SQL rules — what is allowed, the 1,000-row cap, meaning-based search. SQL rules and limits
  • Reuse a query — keep it in the library and pin it to reports. Saved queries
  • Let viewers choose dates — variables, the report time range and comparing with the previous period. Variables and time range
  • See how big your data is — storage, and speed-up indexes. Storage and indexes
  • Query other databases — MySQL, PostgreSQL, MongoDB or a JSON API. Data sources

Before you start

  • Who can use it: the Analytics & reports app on the Roles page. Can query & read lets you open reports, run queries and see only the data you may already read. Full control adds creating, editing and deleting reports and saved queries for everyone, adding indexes, and connecting data sources. Full control + public links also lets you share reports outside the workspace by link.
  • Analytics cannot be switched off in Settings › Apps.
  • Your workspace's own data is already queryable. For other databases you first add a connection.

Where to find it

Launcher category Intelligence › Analytics & Reports. The left rail has:

  • Reports — your report pages as cards.
  • Saved queries — the reusable query library.
  • Query workspace — the full-screen SQL tool.
  • Data sources — connections to other databases.
  • Alerts — numbers you watch, and when they last crossed their line.

Key ideas

Term What it means
Query One read-only SQL SELECT statement.
Report A page of widgets, in sections and rows.
Widget A query drawn as a table, chart or metric. Notes, forms and buttons are widgets too.
Saved query A query kept in the library so many reports can pin it.
Home page The report you see on your dashboard instead of the standard console.
Tag A label used to group reports. A report can carry many.

In this section

  • Alerts on a number — Get told when a number from your data crosses a line — cash below a level, overdue invoices above a count — checked every 15 minutes, hour or day.
  • Arrange a report — Organise a report into sections and rows, resize widgets, drag them into place, or edit the page layout directly.
  • Chart types — Pick the right chart for a report widget — stacked and 100% bars, area, bar + line, funnel, pivot table, gauge and the India state map.
  • Create a report — Create an empty report, add your first widget and save it for your team.
  • Data sources — Connect MySQL, PostgreSQL, MongoDB or a JSON API and query it from the workspace with the same SQL, read-only.
  • Export all rows of a query — Get every row of a query result, past the 1,000 rows shown on screen, as a CSV or Excel file in My Drive or as a new Sheets workbook.
  • Favourites, home page and tags — Star the reports you use most, make one your dashboard home page, and group reports with shared or personal tags.
  • Print or download a report — Print a report page or save it as a PDF, download a chart as a PNG image, copy it, or download a widget's rows as CSV.
  • Query workspace — Write or generate a query, run it, switch between table and chart views, save it, export it or open it in Sheets.
  • Report history — Undo a bad edit to a report page: see who saved each version, preview any earlier one and restore it, and undo the restore the same way.
  • Saved queries — Keep a query in the shared library so several reports can pin it as a chart, headline number or table, and find, reuse or delete saved queries.
  • Schedule a report — Get a report page by email or WhatsApp every day, week or month at a time you choose. Each person receives only what they can see.
  • Share a report — Share a report page outside your workspace with a read-only link or an embed code, with an expiry date and an optional password.
  • SQL rules and limits — What the query workspace allows, the 1,000-row and time limits, how tables and columns map to your data, and meaning-based search.
  • Storage and indexes — See how much space each table uses, inspect columns and relationships, and add or remove indexes that speed up queries.
  • Variables and time range — Add placeholders to a query so viewers can pick dates or values, and give a report its own time range.
  • Widgets — Every kind of widget a report can hold, how to add each one, and every setting in the Configure widget dialog.