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)

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.

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!

You don’t need a national survey to know that most data teams rebuild the same charts again and again across different dashboards. We’ve all been there, staring at a new dashboard request and thinking "I know we've built something like this before..."?

Your best dashboard components deserve to live multiple lives, not buried in some report from last quarter, waiting to be rebuilt from scratch.

With Reusable Component Library, every visualization you create can become a building block for future dashboards. Think of it as your team's collective intelligence, transformed into drag-and-drop components. When you need it again, simply grab it from your library, tweak it, and you're done.

And we're just getting started. Soon, you'll be able to reuse entire metrics and datasets too.

For more information, please visit our documentation

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