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 EnglishAI 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 ExcelExplore 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 timeSaved Views remember your filters; star one and the report opens with it.
Go from a summary to the detailDrilldown & 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 changesScheduler & 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 ExcelDownload 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.

  1. Set the report's filters the way you want them.
  2. Click the binoculars icon in the top bar to open Saved Views, then Save view, and give it a name.
  3. 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.

LevelWhat you writeUse
No codeNothing: drag attributes into "For every" and "Show me"Creating Visuals, with over 30 chart types
No codeA table of rules: when this, then thatDecision Tables, to band numbers into labels or colours
Spreadsheet-style= col2 * col3 over a table's columnsCalculated Fields, for one tile
SQLAn expression in your database's SQL, defined onceCustom Attributes, reused across every tile and report
SQLA reusable model: calculated objects (tables from a query), new objects, relationshipsReusable Data Model, shared by every report on the datasource
SQLA full query, even across datasourcesCreating 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.