Monday morning. Board meeting coming. Your boss needs metrics, and they need it fast. Yet, you find yourself scrolling through cluttered information and interwoven dashboards.

What if you can navigate complex data stories as easily as browsing your favorite website?

This is why we’ve built Tabs for Canvas Dashboards: your data story gets structured and you can break things into neat little sections, like chapters in a book.

Why you'll love it:

• Jump to the right section with one click.
• Group related charts and metrics together.
• Keep filters synced across tabs for a smooth experience.

And yes, your filters stay synchronized across tabs, because continuity matters.

If you have any feedback for us, share it here. We're all ears!

Data leaders switch from Looker to Holistics for better value-for-money, a more flexible self-service layer, and robust query and modeling capabilities.

But we know migration is never simple.

You've spent months perfecting your LookML models. They contain your business logic, calculated fields, and carefully designed relationships. Starting over feels like building a house twice.

We're removing that barrier.

Coming soon: Our Looker Migration tool that transforms your LookML projects into Holistics' AMQL with just a few clicks. Here's what you'll love:

• Upload your existing LookML project during onboarding
• Watch as we automatically convert compatible elements to AMQL
• Follow our comprehensive migration guides for advanced customizations

No more starting from scratch. No more manual translations of every model and view.

Your data models represent months of work and business logic. Now they can come along for the journey to a more flexible, powerful analytics experience.

For more details, check out our documentation here.

Ever stared at a table that just... didn't match the rest of your beautiful dashboard? Those days are over.

With our new Table Styling feature, you can now:

• Apply presets for quick table styling without writing any code, or
• Create advanced, theme-based customizations with full control over every part of your table.

Whether you want subtle alignment with your brand or bold, eye-catching data displays, you now have complete control over how your tables present your valuable insights.

For more details, check out this doc: Theme for Canvas Dashboard.

Besides View Underlying Data, you now get Drill down to dig deeper to understand what's driving your numbers.

Drill Down allows users to easily explore a data value across specific dimensions in just a few clicks. It requires zero setups and offers a smart list of suggested dimensions for a smoother analytics experience. Now available to all users.

Supported visualizations include:

• Line chart family: line/column/bar/combination/area.
• Pie chart family: pie/donut/pyramid/funnel.

For more details, check out this doc: Drill Down.

Ever seen a spike in your chart and wondered "What's really going on here?" or "Why does this number look the way it does?"

Our new View Underlying Data feature makes answering these questions easier. With just a click, you can instantly see what makes up any value at its most granular level.

It requires zero setup. You can easily customize your view by adding or removing columns from the underlying table, giving you complete control over your analysis.

Supported visualizations include:

• Line chart family: line/column/bar/combination/area.
• Pie chart family: pie/donut/pyramid/funnel.

We’re excited to introduce the AQL Quick Reference to simplify writing AQL. This feature serves as an in-editor reference, offering quick access to AQL functions, operators, and practical examples without switching back and forth between the Holistics and doc pages:

• In-Place Search: Find AQL info without leaving the editor.
• Concise Info: Easy-to-understand, bite-size details.
• Practical Examples: Ready-to-use AQL snippets for seamless coding.

Enhance your productivity with this handy AQL Quick Reference and make AQL coding a breeze 💪

Bonus: When reading the docs, there are two cheatsheets that can help you find the functions and operators info quickly:

• AQL Cheatsheet - Functions
• AQL Cheatsheet - Operators

What's New​

We're excited to announce a major upgrade to our AQL (Analytics Query Language) experience with our new enhanced Error Handling System. This update transforms how you interact with AQL by providing immediate, clear, and actionable feedback as you write queries.

Key Improvements​

• Static Type-Checking: Errors are now detected while you type, not when you run your query (feedback on relationshiops, joint requirements, proper nestings, etc).
• Stack Traces: Easily identify where errors originate within complex queries
• Highlighted Error Locations: Visual indicators show exactly where issues occur
• Documentation Links: One-click access to relevant documentation for deeper learning

Getting Started​

This feature is automatically enabled for all users on AQL-enabled datasets and reports. Simply open the AQL editor and start experiencing the benefits of real-time error feedback.

• Check out full AQL error reference here.
• Check out our troubleshooting guide here

We're excited to announce a new feature that's now available: the ability to display metrics as rows in Pivot Table.

The Problem We've Solved​

Previously, metrics could only be shown as columns in pivot tables. This made it difficult to compare multiple metrics, especially when you had many of them, as you ended up scrolling horizontally to see all your data.

The Solution​

You can now switch your pivot table layout with a simple toggle:

• "Show as columns" (current default)
• "Show as rows" (new option)

Benefits​

• Compare multiple metrics naturally within a single view
• See more of your data without constant scrolling
• Adapt your table layout to fit your specific analysis needs

Documentation​

Pivot Table | Holistics Docs (4.0)

Why Spreadsheet Analysis Is Still A Pain​

Picture this: It's Monday morning, and your stakeholder needs insights from that customer survey data sitting in a spreadsheet. Or maybe you want to combine your CRM export with existing metrics for a one-time analysis. In traditional BI setups, you're looking at:

• Waiting for data engineering resources
• Complex ETL pipeline setup for temporary data
• Database permissions and access hurdles
• Hours or days before you can start analyzing

What if you could skip all that and go straight to insights?

The Solution: Import Data Through Holistics​

Imagine this instead: You drag your CSV file into Holistics, and it loads straight into your database. Within seconds you're building charts and dashboards.

No IT tickets, no manual setup, no waiting around.

We're working on seamless CSV and Google Sheets import that drops your data directly into your existing warehouse, automatically creates data models with proper field types, and lets you start analyzing immediately.

Your data stays in your own infrastructure, gets proper validation and configuration. You can also re-upload your source file to keep things fresh. From raw file to actionable insights in a minute.

Want early access? Reach out to us via a support ticket!

We're introducing a new Pull Request (PR) workflow to help organizations maintain quality and control over their dashboard changes. This feature empowers administrators to implement a robust review process before changes go live.

Why We Built This​

Have you ever discovered unexpected changes in your production dashboards? While you can track down who made the changes, by then the damage is already done.

The root cause? A lack of mandatory review process for dashboard changes. Without proper oversight, unrestricted publishing can compromise your project's reliability and integrity.

Key Features​

The new PR Workflow includes:

• Company-wide Control: Administrators can enable/disable the PR Workflow for their entire organization
• Review Management: Administrators and Dashboard Owners can review all changes before they go live
• Streamlined Process for Analysts:
  • Easy submission of changes for review
  • Automatic publishing after PR approval and merge
  • Instant notifications if any errors occur during publishing

For detailed information, check out our PR Workflow documentation.