BI USER HANDBOOK

Learn Holistics by Doing

A self-serve handbook for business users. Each lesson is a quick preview you can do in minutes: what it's for, a short walkthrough, and the few steps to try it. Learn at your own pace and ask AI for help as you go.

New to Holistics? Ask AI to guide you.

Instead of hunting through dashboards, ask a question in plain language. Holistics surfaces trusted dashboards, charts, and answers, and can explain how to use the platform as you go.

“How do I filter this report?” “What dashboard should I use for customer retention?” “How do I create my own report?” “Can you explain this metric?”

Getting Answers Quickly

Start here. Get useful answers in minutes with AI.

Start with Ask AI

Ask a business question and get a trusted chart or dashboard back.

2 min First-time users
Show the steps
  1. Open Ask AI.
  2. Type your question in plain language.
  3. Review the suggested chart or dashboard.
  4. Open the related report to explore further.
Full guide

Share an Ask AI Conversation

Send an AI-assisted analysis to a colleague with a link.

2 min Collaborators
Show the steps
  1. Open the conversation.
  2. Copy the share link.
  3. Send it to teammates inside your company.

Conversations are retained for a limited time, so save important charts to a dashboard.

Full guide

Ask Follow-Up Questions

Clarify a metric, trend, or spike from the chart itself.

2 min All users
Show the steps
  1. Open the chart or AI result.
  2. Open the AI side panel.
  3. Ask your follow-up question.
  4. Read the explanation.
Full guide

Summarize a Dashboard with AI

Get a plain-language summary of what a dashboard is showing.

3 min All users
Show the steps
  1. Open a dashboard.
  2. Select the widgets you care about.
  3. Ask AI to summarize them.
  4. Review the summary.
Full guide

Make AI Company-Aware

Tune AI to your own terms and metrics, package repeatable workflows as skills, and bring Holistics answers into your own tools. These are set up with your data team.

Company Knowledge & Context-Aware AI Guidance

Help Ask AI understand your terminology, metrics, and workflows.

Record new: concept clip (roadmap-gated)
4 min BI/data teams
Show the steps
  1. List your company terms, metrics, and recommended dashboards.
  2. Share them with your data team.
  3. The data team builds context files.
  4. Ask AI questions and refine over time.

This is direction-of-travel; confirm what's available today with your data team.

Full guide

Suggest Organization-Specific AI Skills

Package a repeated analytical workflow as a reusable, governed AI skill.

4 min Power users
Show the steps
  1. Identify a repeated workflow or question.
  2. Describe what the AI skill should help with.
  3. Share examples with your data team to build and govern it.
  4. Help test whether the skill produces useful results.
Full guide

Use Holistics from Your Own AI Interface

Connect Holistics to your chat or command-line tools via MCP.

4 min Teams with IT support
Show the steps
  1. Identify the internal AI interface you want answers in.
  2. Ask your data or IT team whether Holistics can be connected.
  3. Define what types of questions to support.
  4. Test responses with governed data access.
Full guide

Exploring Dashboards & Reports

Go beyond a static answer. Slice, drill, and inspect the data.

Interact with AI-Generated Charts

Hover, filter, and drill into an AI result instead of reading a static chart.

3 min All users
Show the steps
  1. Review the AI-generated chart.
  2. Hover or click to inspect values.
  3. Open the report.
  4. Filter or drill into the data.
Full guide

Filter a Dashboard or Report

Narrow results by time, region, segment, or product, even by hidden fields.

3 min All users
Show the steps
  1. Open a dashboard or report.
  2. Add or edit a filter.
  3. Pick the field and value.
  4. Apply and review the result.
Full guide

Cross-Filter a Dashboard

Click a chart to filter every related chart on the dashboard at once.

3 min All users
Show the steps
  1. Open a dashboard with cross-filtering enabled.
  2. Click a value or segment in any chart.
  3. Watch the other charts filter to match.
  4. Click again to clear the cross-filter.

Cross-filtering is turned on by your data team when building the dashboard.

Full guide

Filter to Top or Bottom N

Show only the highest or lowest N records, applied after your other filters.

3 min All users
Show the steps
  1. Open a report in exploration mode.
  2. Add a top/bottom N filter on the metric.
  3. Set N and the ranking direction.
  4. Apply and review the ranked result.
Full guide

Drill Down into a Metric

Move from a high-level number into the detail driving it.

3 min All users
Show the steps
  1. Click a metric or chart segment.
  2. Choose a drill-down dimension.
  3. Review the breakdown.
  4. Keep drilling as needed.
Full guide

View Underlying Data

Inspect the individual records behind a number.

3 min All users
Show the steps
  1. Click the metric or chart element.
  2. Choose "view underlying data".
  3. Inspect the record-level table.
  4. Export only if permitted.
Full guide

Drill Through to Another Dashboard

Jump from a summary view to a related detail dashboard.

3 min All users
Show the steps
  1. Click the metric, row, or record.
  2. Pick the drill-through destination.
  3. Continue analysis in the destination dashboard.

This usually requires your data team to set up the workflow first.

Full guide

Creating & Saving Your Own Analysis

Safe self-service. Customize and save without touching official dashboards.

Explore a Report

Adjust dimensions and measures for your own analysis.

Explore a Report preview
4 min Self-service users
Show the steps
  1. Open the report.
  2. Enter exploration mode.
  3. Add or remove fields.
  4. Save to your personal workspace if useful.
Full guide

Use AI to Add a Custom Field

Ask AI to build a calculated field without writing the logic.

Use AI to Add a Custom Field preview
4 min Self-service users
Show the steps
  1. Open a report in exploration mode.
  2. Ask AI to create a calculated field.
  3. Review and apply it.
  4. Save the report if useful.
Full guide

Build a Calculated Field Without Code

Create, customize, and compose metrics with a point-and-click GUI — no AQL required.

4 min Self-service users
Show the steps
  1. Open a report in exploration mode.
  2. Open the Calculation Builder from the dataset fields panel, visualization settings, or a table.
  3. Pick a calculation — sum, average, count, running total, or a conditional metric.
  4. Apply it, then save the report if useful.

New calculation types include Concat, Date difference, Date add, Case when, and Rank, so you can work with text, dates, and rankings too. You can switch between the GUI and Formula (AQL) view at any time, and view the generated AQL to learn the language as you go.

Full guide

Create Arithmetic Calculations

Combine fields with +, −, ×, ÷ to build metrics like profit margin or conversion rate.

Create Arithmetic Calculations preview
3 min Self-service users
Show the steps
  1. Open the Calculation Builder on your report.
  2. Choose an arithmetic operation (+, −, ×, ÷).
  3. Pick the two fields or metrics to combine, for example Revenue − Cost for gross profit.
  4. Apply and review the new metric.

Arithmetic calculations can be composed with existing metrics, or converted to AQL for further customization.

Full guide

Create Period-over-Period Comparisons

Compare current vs previous period in a few clicks.

4 min Self-service users
Show the steps
  1. Open a report in exploration mode.
  2. Click the metric you want to analyze.
  3. Choose period-over-period comparison.
  4. Select the comparison period.
Full guide

Create a Running Total

Accumulate a metric across a dimension, like running revenue by month.

3 min Self-service users
Show the steps
  1. Open a report in exploration mode.
  2. Click the metric.
  3. Choose running total.
  4. Pick the dimension to accumulate across.
Full guide

Add Moving Calculations

Smooth noisy trends with moving averages and measure change over time.

3 min Self-service users
Show the steps
  1. Open a report in exploration mode.
  2. Click the metric.
  3. Choose a moving calculation, such as a moving average.
  4. Review the smoothed trend.
Full guide

Show Percent of Total

Convert a metric into contribution percentages.

Show Percent of Total preview
3 min Self-service users
Show the steps
  1. Open a report in exploration mode.
  2. Click the metric.
  3. Choose percent of total.
  4. Review the updated calculation.
Full guide

Add a Trend Line

Overlay a trend line to see the direction behind the data points.

2 min Self-service users
Show the steps
  1. Open a chart in exploration mode.
  2. Open the analytic functions menu.
  3. Add a trend line.
  4. Pick the trend line type if needed.
Full guide

Add a Reference Line

Mark a target, average, or threshold line on a chart.

2 min Self-service users
Show the steps
  1. Open a chart in exploration mode.
  2. Open the analytic functions menu.
  3. Add a reference line.
  4. Set the value or field it should mark.
Full guide

Create Advanced Nested Conditions

Combine AND/OR grouped filters without SQL.

5 min Power users
Show the steps
  1. Open a report in exploration mode.
  2. Add a filter condition.
  3. Group conditions together.
  4. Combine AND and OR logic, then apply.
Full guide

Save to Personal Workspace

Keep your own version of an analysis, privately.

Save to Personal Workspace preview
2 min Self-service users
Show the steps
  1. Finish your exploration.
  2. Click save.
  3. Choose your personal workspace.
  4. Name the report clearly.
Full guide

Export to CSV or Excel

Continue analysis offline, where permitted.

2 min All users
Show the steps
  1. Open the report.
  2. Click export.
  3. Choose CSV or Excel.
  4. Download the file.

Export permissions may be controlled by your data team.

Full guide

Design & Style Your Dashboard

Make your dashboards clear, branded, and great to look at.

Get to Know Canvas Dashboards

Learn the building blocks, and place filters and content anywhere you like.

Get to Know Canvas Dashboards preview
3 min All users
Show the steps
  1. Open a canvas dashboard.
  2. #
  3. Drag components anywhere on the canvas.
  4. Place filters where they make sense, not just at the top.

Unlike fixed dashboards, a canvas dashboard lets you position filters anywhere on the page, not only across the top.

Full guide

Adjust Dashboard Settings

Control layout, grid, and zoom so the dashboard looks right on any screen.

3 min All users
Show the steps
  1. Open the dashboard settings panel.
  2. Set the layout and grid options.
  3. Adjust zoom and responsive behavior.
  4. Save your settings.
Full guide

Find Your Way Around the Visualization Interface

Know where the chart selector, Configure panel, and toolbar actions live.

3 min All users
Show the steps
  1. Pick a chart type from the chart selector.
  2. Open the Configure panel to set fields and options.
  3. Use the toolbar for Analyze, Ask AI, filters, and sort.
  4. Run to preview your result.
Full guide

Add Conditional Formatting

Highlight values that cross a threshold.

3 min All users
Show the steps
  1. Open the report.
  2. Choose conditional formatting.
  3. Define the threshold.
  4. Pick the style and save.
Full guide

Wrap Content & Set Custom Labels

Tidy tables by wrapping header or cell text and renaming fields with custom labels.

Wrap Content & Set Custom Labels preview
3 min All users
Show the steps
  1. Open a table visualization's style settings.
  2. Turn on text wrapping for headers or cells.
  3. Set a custom label to rename a field.
  4. Save the styling.
Full guide

Change Colors & Style

Restyle a chart or table with your own colors and formatting.

3 min All users
Show the steps
  1. Select the chart or table.
  2. Open its style settings.
  3. Change colors, fonts, and borders.
  4. Save your changes.
Full guide

Use Custom Charts

Go beyond the built-in charts with open-source visualizations.

Use Custom Charts preview
4 min Power users
Show the steps
  1. Open a report and add a custom chart.
  2. Paste or adapt a visualization spec.
  3. Map your fields into the chart.
  4. Save it to your dashboard.

Adding a custom chart may need your data team's help. For inspiration, browse the Vega-Lite example gallery to see how flexible the presentation can be.

Full guide

Build Dynamic Content Blocks

Create rich blocks like KPI cards, heatmaps, and metric trees from templates.

Build Dynamic Content Blocks preview
5 min Power users
Show the steps
  1. Browse the template gallery for a starting point.
  2. Add a Visualization block and choose the Markdown type.
  3. Map your data fields into the template.
  4. Adjust the design to taste.

Tip — ask AI to generate the block design for you. Browse the template gallery to get started.

Full guide

Build Rich Layouts with HTML & CSS

Design branded, web-app-like dashboard themes and layouts.

5 min Power users
Show the steps
  1. Open the Theme Builder Sandbox.
  2. Pick a pre-built theme, generate one with AI, or start from scratch.
  3. Customize colors, spacing, and layout in the live GUI editor.
  4. Copy the generated theme into Holistics, or send it to your data team to apply.
Full guide

Deliver, Share & Act on Data

Get insights to where they are needed, share selected views externally, and trigger action from a report. Most of these are set up with your data team. Need more access to do them yourself? Ask your data team.

Set Up Alerts

Be notified when a metric crosses a threshold.

Set Up Alerts preview
3 min All users
Show the steps
  1. Pick the metric to monitor.
  2. Define the alert condition or threshold.
  3. Choose the channel (email, Slack, or webhook).
  4. Ask your data team to set it up.
Full guide

Schedule Report Delivery

Have recurring reports sent automatically.

Schedule Report Delivery preview
3 min All users
Show the steps
  1. Pick the report or dashboard to send.
  2. Choose the delivery schedule.
  3. List the recipients and channel.
  4. Ask your data team to set it up.
Full guide

Share a Report Internally

Let teammates see your saved analysis with the right access.

Share a Report Internally preview
3 min Collaborators
Show the steps
  1. Open the saved report.
  2. Click share.
  3. Choose users or groups.
  4. Confirm the access settings.

Check with your data team if you are unsure whether a report should be shared broadly.

Full guide

Share a Live Exploration Link

Send a colleague the exact view you're looking at. Every field you add, change, or remove updates a unique, shareable URL.

Walkthrough coming soon
2 min All users
Show the steps
  1. Open a report and enter exploration mode.
  2. Add, edit, or remove fields and filters. The URL updates as you go.
  3. Copy the URL straight from your browser.
  4. Send it to a teammate so they open the same view.

The link respects permissions, so teammates only see it if they already have access to the underlying data. Handy for collaboration, getting a second opinion, or troubleshooting a number together.

Full guide

Create Shareable Links

Share selected reports externally, safely.

3 min All users
Show the steps
  1. Pick the report or dashboard to share.
  2. Define the external audience.
  3. Decide on password protection and expiry.
  4. Ask your data team to create the link.
Full guide

Set Up Product Actions

Trigger an operational workflow directly from a report.

Set Up Product Actions preview
3 min All users
Show the steps
  1. Pick the report or record where the action should appear.
  2. Describe the action users should trigger.
  3. Name the destination system or workflow.
  4. Ask your data team to set it up.
Full guide