Reports

A report is a saved query turned into a page anyone on your team can open: a few filters at the top, a table underneath, and no SQL to read. Send someone a link instead of pasting numbers into a message.

Creating a report

Open a saved query, run it, and click Create report above the results. Reports are listed for everyone in your company, so if the query is still private you will be asked to share it with your team first. Once created, it shows up in the Reports tab of the sidebar for everyone.

Reports keep the folder their query lives in, so filing a query in the editor also files its report. The full list is at /app/reports, with those folders, a search across titles and descriptions, and each report's description under its title. Give a report a description if several of them look alike: that line is what a reader picks from.

Filters

The report's filters are the query's query variables, one input each. Dates get a date picker, dropdowns get a list of the options you defined. Change a value and press Update to run again.

A report runs by itself when it opens, so there is something to read straight away. If a required filter has no value, it waits and asks you to fill it in first.

Sharing a link

The Copy link button at the bottom of the report gives you a link to exactly what is on screen, filter values included. Values you left on their default are left out of the link, so a report set to “the last 30 days” still means the last 30 days whenever your colleague opens it.

The link only works for people signed in to your company. Anyone else gets a not-found page.

If the person you are sending it to has no business writing SQL, give them the viewer role: reports and nothing else.

Exporting the numbers

CSV, Excel and JSON are at the bottom of every report, next to the row count. A report shows up to 1000 rows, 100 at a time. For anything bigger, or for numbers that should arrive without anyone opening a page, use scheduled queries instead.