Release Notes

Here's a cool experimental feature that our team hacked together: A Google spreadsheet extension that allows you to self-serve BI datasets directly in Google Sheets.

It works in 4 simple steps

1. Connects to BI environment
2. Let end users self-serve BI datasets (like a pivot table)
3. Sync results directly as google sheets table
4. Set custom frequency for refreshing data

This will be very useful for users who prefer working with spreadsheets, yet need the reliability of a centralized BI system.

Note: This is an experimental project (born out of our recent hackathon). If you’re a customer of Holistics and interested, fill our Early Request Form here and we’ll let you know when it’s available for beta.

We’re excited to announce that our integration with MotherDuck is now available, allowing you to combine the robust, scalable data processing power of MotherDuck with Holistics’ governed self-service platform.

For more information, check out our docs here.

Ever created a running total that worked perfectly in a simple table, but showed gaps when you pivoted by another dimension? We've added a solution for that.

Learn more​

See the full documentation: running_total function reference

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.

Documentation​

For details, visit our public documentation: https://docs.holistics.io/docs/dashboards/tabs

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