Skip to main content
← All apps

Reports & analytics

Reports

This manual is a draft and may change.

What it does

Reports lets you slice your business records, save the views you use often, download them as spreadsheet files and, if you wish, feed them into Google Sheets with a private live link. You choose from lists, so you can never break or expose anything by accident.

Who uses it

  • Staff who read figures (Reports viewer): open saved reports and download them.
  • Staff who build views (Reports editor): also create, save and archive reports and make Google Sheets links.
  • Finance staff (Reports finance): may include money columns.

Setup

  1. Ask your 1vsM contact to install Reports on your site.
  2. It installs these first, automatically: Access.
  3. Give each person the role that fits: Reports viewer, Reports editor or Reports finance.
  4. Install the apps whose records you want to report on. Record lists to choose from come from other apps; so far only the Finance apps provide them, and your web team must connect them. Until at least one is connected, the Reports tab says no datasets are registered.
  5. If you want Google Sheets live links, ask your 1vsM team to switch them on for your site; they need a private key set up once.

Admin tasks

Reports

  1. Open Reports in the admin menu.
  2. Under Saved reports you see each report's Name, Dataset, Updated date and Actions. Press Open to load one, Export CSV to download it, or Archive (editors only) to retire it.
  3. To build a new one, pick a Dataset under Build a report and press Use dataset.
  4. Under Shape, choose Rows — one line per record and tick the columns you want, or Summary — group and total and pick Group by, Then by, Calculate and Of column; optionally Pivot across.
  5. Under Filters, choose a column, a condition and a value; "between" also needs the second value.
  6. Choose Sort by, Direction and Row limit, then press Run preview to see the result.
  7. Type a Report name and press Save report (or Save changes when editing). Only editors see these.
  8. Editors can open a saved report and, under Google Sheets live link, choose Expires after and press Create live link. Copy the address immediately; it is shown only once. In Google Sheets use it with the IMPORTDATA function.
  9. To stop a link working, press Revoke beside it. Archiving the report also stops its links.

Member view

Members do not see this app. Only Google Sheets, holding a live link you created, can read a report from outside.

Styling it to your brand

This app takes its colours, fonts and corners from the brand profile entered once in 1vsm.com's Brand intake. That profile applies to every app automatically, so there is nothing to set up here. A few parts of this app still use fixed colours and will match your brand after the next update.

Troubleshooting

  • There is no Reports tab. You need one of the Reports roles.
  • "No datasets are registered on this site yet." No app has offered any records to report on yet; your web team has to connect one.
  • "This report uses finance columns (needs reports.finance)". The report touches money columns; ask for the Reports finance role.
  • "a report named ... already exists". Report names are unique; choose another.
  • "Live links are not configured on this site yet." Ask your 1vsM team to set up the private key.
  • Google Sheets shows an error or old data. The link may have expired or been revoked; create a new one.
  • "pivot has more than 50 distinct values". Filter the data or group by month or year instead.

FAQ

Can I edit data here? No. Reports are read-only views.

Can I write my own query? No, by design; you choose from lists.

Who can see a live link's data? Anyone who has the address, until it expires or you revoke it, so treat it like a password.

Is every download recorded? Yes, exports and live-link fetches are logged.

What is the biggest report? Up to 10,000 rows.

What to connect

Nothing to connect: this app works with what is already on your site. Your brand colours, contact details and social links come from Set up your site.