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.

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. |
Related
- Export all rows of a query — past the 1,000 rows shown on screen
- Ask Axis can run queries and build report pages for you.
- Sheets — open a result in a spreadsheet.
- Knowledge Base