What's New

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)

Now you can search for anything in your entire Development workspace, with our new Code Search feature!

🎉 What Is Code Search?​

A functionality that enables you to look for any piece of code through your entire data project.

This means you can:

• Find every file where a metric, model, data source,... is referred to
• Plan your refactoring with confidence by seeing every affected file
• Search by description, label, and other criteria to find exactly what you need
• And even more to come: Replace search results with another piece of code; Filter results by object type; etc...

📝 A Few Notes​

This is an early access release of the Code Search feature. Therefore, you may notice some rough edges in the design and experience. We’d love to hear your feedback, as it will help us polish this feature and directly shape the final version.

Try it out today, and share your thoughts via our Community, or the in-app support form!

Tracing and investigating file changes has never been easier!

🎉 What's New​

Now you can directly access your files on GitHub / GitLab with a single click, right from the Holistics interface:

• View source code directly in GitHub/GitLab
• Access Git blame to track code changes and authorship
• Review complete file history and previous versions

This enables seamless navigation between Holistics and your Git repository.

🏋 Why This Matters​

If you ever wondered "Who modified this data model?", "When did it happen?", or "Why?", then this feature is for you.

Our new Git integration lets you answer these questions instantly. Whether you're debugging an issue, reviewing changes, or understanding the evolution of your data models, you now have direct access to the full history and context of your code.

Give it a spin, and let us know your thoughts. Cheers! 🍻

---

Note: This feature is currently available for GitHub and GitLab repositories only. Support for other Git providers will be announced in future updates.

You can now fully customize Schedule and Alert messages with system variables! This gives you complete control over notification content while saving time with dynamic variables.

Key Features​

• Full message customization (no more fixed templates!)
• System variables support (e.g., {{dashboard title}}, {{this month}})
• Live preview functionality
• One-click restore to default template

Documentation​

• Data Schedule
• Data Alert

You can now connect to Snowflake using key/pair authentication instead of the regular username/password.

When your Private Key is specified, Holistics will ignore Password and use only key-pair authentication.

For more details, please refer to our Snowflake Connection doc.

Period Comparison has consistently been a favorite among our customers, serving as an early tool to facilitate period-over-period analysis (PoP). However, ongoing customer feedback has highlighted its limitations in flexibility and customizability.

Leveraging our robust AQL foundation, we have developed a new and advanced PoP feature. This enhancement combines the power of AQL with an intuitive user interface, capable of handling all the use cases that the previous version could not accommodate. Key improvements include:

• The ability to apply comparisons to individual measures of your choice, rather than to all measures in a visualization.
• Support for comparing multiple periods simultaneously.
• Options for applying conditional formatting and custom styling.
• The capability to set data alerts on PoP measures.

These enhancements are designed to offer a more versatile and user-friendly experience, meeting the diverse needs of our user base.

You can learn more about the new feature here: Period-over-Period Comparison