Self-Service Analytics
Answer your own questions without waiting for a developer, and without learning a new formula language. Readers use plain English and Excel formulas; builders use drag and drop, no-code rules and, when they want it, SQL.
ℹ️ The principle
Self-service in PersivX uses languages people already know: plain English for questions, Excel formulas for working with numbers, and SQL for developers. There is no proprietary formula language to learn. Everything a reader does runs through the same column masking and row-level security as the report itself.
For Readers
Everything here works on reports that are already published. None of it changes the report for anyone else.
| I want to… | Use |
|---|---|
| Ask a question in plain English | AI Summaries & Q&A: ask a report a question, or have it summarize a visual. Needs AI switched on for your organization and your account. |
| Work with the numbers myself, like in Excel | Explore Data, from the ☰ menu on any visual: a spreadsheet over the visual's data with 231 Excel functions, column formulas, sorting, filtering, pivots and charts. Downloads to Excel keep the formulas. |
| See only my slice, every time | Saved Views remember your filters; star one and the report opens with it. |
| Go from a summary to the detail | Drilldown & Drill-Through: click into a chart or table, or jump to a linked report with your context. |
| Get it sent to me, or be told when something changes | Scheduler & Smart Alerts: schedule a report or visual to yourself, or set an alert that sends only when a condition is met. Needs Scheduler Access, which users have unless an admin turns it off. |
| Take it into Excel | Download any table, or schedule an Excel attachment. See Working with Tables. |
Saved Views
A saved view is a named set of filters on a report, kept for you. Use one for each slice you look at often: your region, last quarter, a key customer.
- Set the report's filters the way you want them.
- Click the binoculars icon in the top bar to open Saved Views, then Save view, and give it a name.
- Click a view's name to apply it later.
- Your default view: click the star next to a view and the report opens with it every time you sign in. Click the star again to stop.
- Clear removes every filter you've applied; the trash icon deletes a view.
- Views belong to you and to that report. Other people don't see them, and saving one doesn't change the report.
- A subscription can run with a saved view, so a scheduled report arrives filtered the same way (Run With a Saved View).
- Saved views need you to be signed in, so they aren't available on reports opened without signing in.
For Report Builders
Building and changing shared reports needs a Developer licence. Builders choose how much code they want to write: none, a spreadsheet-style formula, or SQL.
| Level | What you write | Use |
|---|---|---|
| No code | Nothing: drag attributes into "For every" and "Show me" | Creating Visuals, with over 30 chart types |
| No code | A table of rules: when this, then that | Decision Tables, to band numbers into labels or colours |
| Spreadsheet-style | = col2 * col3 over a table's columns | Calculated Fields, for one tile |
| SQL | An expression in your database's SQL, defined once | Custom Attributes, reused across every tile and report |
| SQL | A reusable model: calculated objects (tables from a query), new objects, relationships | Reusable Data Model, shared by every report on the datasource |
| SQL | A full query, even across datasources | Creating Visuals with Queries, Combining Datasources |
Guardrails
- Governance always applies. AI answers, Explore Data, saved views, schedules and downloads all use only what the person may see.
- Readers can't break a report. Their views, sheets and questions are their own; the report stays as its builder made it.
- Shared changes are reviewed. Release pipelines can require named approvers before a changed report reaches its readers.
