Release Notes

Field Promotion allows you to transform your proven ad-hoc calculations into reusable dataset fields, making them easily accessible across all dashboards and reports.

For more details, please refer to our doc.

We’re introducing a simpler, faster way to explore data in Holistics, without the need to write code, tap an analyst on the shoulder, or even build charts by dragging and dropping. You just need to chat with Holistics AI.

Built on top of our governed semantic layer and metric-first query language, Holistics AI is designed to help teams explore data and build charts through natural language, all while staying grounded in trusted, curated datasets.

Holistics AI is currently in development. If you’d like early access and want to help shape how it evolves, you can join the waitlist here.

Here’s a quick look at how it works in action.

What You Can Do With Holistics AI​

• Explore Data (With Thinking): This mode helps you work through complex questions by thinking step-by-step. Holistics AI dynamically builds the logic and fields it needs to answer the data questions.

• Explore Data (Basic Mode): For simpler use cases, Basic mode gives you a fast, code-free way to build visualizations. Just type your question and let Holistics AI pick the fields without needing to drag and drop components or write a single line of SQL.

• Search Docs: Search Docs lets you quickly search and browse documentation without leaving Holistics, so you don’t have to hunt through shared folders or ask your team for links.

TL,DR: What Holistics AI Can Do​

Here’s a quick look at what Holistics AI can do in this upcoming Alpha release:

• Listing: “List all products launched in the last quarter”
• Filtering: “Show transactions over $1000 from new customers”
• Top/Bottom N: “What are our top 5 performing stores by revenue?”
• Metric calculations: “Calculate average order value by customer segment”
• Aggregation and breakdown: “Break down sales by category and region”
• Percent of Total: “What percentage of total revenue comes from each product line?”
• Period Comparison: “Compare this month’s sales to the same month last year”

What’s Coming Next​

Here’s a glimpse of what’s on the way:

• Customize Chart: Make quick adjustments using natural language.
• Explain Chart: Understand trends and patterns through auto-generated insights. We’re building these features to give you more flexibility and clarity as you explore your data.

Want Early Access?​

Holistics AI is in its alpha phase, which means it’s still evolving, and your feedback really matters. It’s already starting to open up new ways to work with data, and we’d love for you to be part of the journey.

If you’re interested in trying it out and helping shape what comes next, join the waitlist and we’ll be in touch.

⚡⚡⚡ Want the full story? Dive into our announcement blog post for all the details! Or read our docs to learn more.

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.

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