Skip to main content

In a time-series report, you may want to group data by different time intervals such as Day of Week, Day of Month, Month of Year, Hour of Day, etc.

Previously, you had to write AQL expressions to extract such date parts from dates. Now, our Date Parts feature helps you easily extract these specific types of dates from time dimensions so that you can slice your data under different time lenses.

For more detailed examples, please refer to this document:


For trend lines and reference lines, in addition to the toggle break down by legend, you also have another toggle, merge into one line, which helps visualize a single global line despite the legend.

Although both toggles produce the same result of one single line in the chart, their calculations differ:

  • Turning off “break down by legend”: This calculates the trend line or reference line based on the total values (i.e., not segmented by legend).
  • Turning on “merge into one line”: This calculates the trend line or reference line based on the segmented values.

For more detailed examples, please refer to these documents:


Previously, every measure in your chart was always broken down by legend. But sometimes, you may want to apply legend to only certain measures, for example, visualizing a total value alongside sub-category values within a chart.

Now, with a simple toggle, you can turn off the “break down by legend” for individual measures, giving you more control over your visualizations.

Supported visualizations include line, area, column, bar, and combination charts.

Note: this feature is only available in AQL-enabled datasets.


Another quality-of-life improvement in Holistics—more data presentation options for Line Interpolation. Now, you can customize how your line charts display changes between data points for better clarity.

A good chart is a chart with great visual clarity, and this little feature helps analysts get one step closer to that.


You can now temporarily hide columns that aren’t relevant to your task, giving you a cleaner, more focused view of your data.

Even better, you can still sort your tables by these hidden fields, keeping your data organized without cluttering your view.

For more information, please visit our public doc here: Data Table | Holistics Docs (4.0).

Note: This is an aesthetics feature, not a security feature. Hiding a column will remove it from the user’s report view and export, but the data is still accessible and not restricted in any way.


We're excited to share some improvement to how you access shared URLs in Modeling 4.0!

Previously, when someone shared a URL to an object in their working branch, you often couldn't access it. This was because the URL still kept you in your current branch instead of redirecting to theirs.

Now, with the addition of the branch parameter in the URL, you can easily navigate to the exact working branch and location of the AML object.

That's not all! We’ve also added a new button to copy the object URL, further enhancing your experience.

Happy navigating among the branches with URLs! 😉


We are thrilled to announce the launch of our highly-anticipated feature: ​Auto Publish!

The Publish API allows you to publish your project outside of Holistics, making integrating with CI/CD workflows easier. This integration unlocks the full potential of an “as-code” approach, enhancing automation and scalability. This is useful for scenarios like:

  • Auto publish the latest update after merging PR into the master branch, by integrating Publish API with the CI/CD workflow.
  • Auto publish the latest update after new changes are pushed to master branch.

Learn more about this feature on Auto Publish (with Publish API)


Dashboards are essential for staying on top of your key metrics. Yet, they are often locked within analytics tools, separated from the daily workflows of business users. This creates extra friction for adoption.

Introducing Public Embedding capability for your Holistics Dashboards.

What's new?

You can now embed interactive Holistics Dashboards into:

  • Blog posts, websites
  • Internal tools (Notion, Coda, wikis)
  • Any platform supporting iframes

This feature allows you to edit, update, and refresh your published content effortlessly. Now, everyone in and outside your organization has access to the most current data in the right context.

How it works

Under the hood, we make our Sharable Link embeddable on the web. Simply follow these steps:

  1. Go to your dashboard.
  2. Click on Share > Sharable Link.
  3. Create a new Sharable Link.
  4. Embed this link in your application.

Considerations

Public Embedding makes your dashboard viewable to anyone on the internet without authentication. Before publishing:

  • Ensure you have permission to share the data publicly
  • Review your organization's data-sharing policies
  • Never publish confidential or proprietary information
tip

To securely embed your content in an internal portal or website, use our Embedded Analytics. This option ensures that all permissions and data security are enforced when your users view your internal data.

See it in actions

Want to see what it looks like? Check out these examples below 👇


This one is password-protected. Use this password: i_love_holistics


Drill-through allows viewers to dig deeper into data by navigating to related dashboards, offering detailed insights on demand. It's now available in Canvas Dashboard!

How to get started

Similar to Drill-through in Dashboard (Legacy), analysts can set up Drill-through in the Canvas Dashboard by enabling the Drill-through toggle in the filters.

In addition, we also introduce further configurations that give you more control over designing the drill paths. Specifically, you have two modes:

reporting-set-up-drill-through-configurations

Auto (default)

  • Automatically links all source dashboards containing widgets from the same dataset as filters on the target dashboards.
  • Disabled dashboard option: You can exclude specific dashboards from drill-through even if they contain relevant widgets. This is useful for dashboards that might technically qualify but aren't contextually relevant.

Custom

  • Allows you to specify which dashboards should be linked to target dashboards manually. Holistics will only link the custom dashboards you select to target dashboards.
  • Gives you precise control over drill-through behavior.

Learn more about the feature at Drill-through | Holistics Docs (4.0).


Today, we introduce you to the powerful new Action feature in Holistics, designed to enhance how you interact with your data reports and dashboards.

With this feature, you can define specific actions to perform directly from your data, making data-driven decisions more efficient and effective.

For more information, please visit our doc about Holistics Actions


Notes: This feature is only available in Canvas Dashboard.

Previously, tables and pivot tables in Canvas Dashboard automatically expanded to fill the entire container width. Sometimes, this leads to excessive whitespace and removes the focus on important information.

Now, you can adjust the width of individual columns in your Table and Pivot Table.

💡 How it works

  • By default, tables and pivot tables still expand to fill the full width of their container.
  • When editing dashboards, you can control column widths by directly dragging the column borders. The new widths will be saved, ensuring your tables and pivot tables maintain a consistent look across all views.

Dashboards don’t have to be boring. With our Canvas Dashboard themes, you can easily make your dashboards a joy to look at.

  • You can define reusable, custom themes, and apply them at different element levels (block and page).
  • Themes can also be extended and built upon, so you don’t have to start from scratch.

For more details, check out our doc here: Themes in Canvas Dashboard | Holistics Docs (4.0).

If you haven’t tried Canvas Dashboard yet, go ahead, give it a try, and check out some awesome samples we've built on our Playground: go.holistics.io/play


Now you can have the freedom to easily customize your table views with a simple drag and drop.

Want your columns in a different order, one that makes more sense to you? No problem! Just drag them around to your heart's content.


No more clunky middle steps like manual synchronizations with your remote repository. Our upgraded Git workflow automatically:

  • Pulls changes from Production before you publish new data models.
  • Checks for any new changes made to your branch.

This streamlines everything, cutting down on context-switching and letting you develop faster.

For more details, check out our doc here.


With our AQL (Analytics Query Language), building complex metrics is easier, but it can still take a few steps to create, test, and refine an AQL field.

We get it—that's why we created a new AQL editor that lets you build metrics directly from the Reporting page. We’ve also added some handy tweaks like better code suggestions, field searching, and improved error handling.

With the new AQL editor, you can also promote your metrics from Visualization settings to your Dataset code, and reuse them anytime, anywhere.


Another small improvement, but guaranteed to make your exploration experience much more pleasant: Now, you can easily reverse the stack order with just a click of the "Reverse Stack" toggle.


With Canvas Dashboard, you can build the most visually stunning dashboard in the world, but no one will know if every dashboard visit is a game of “spin the loading wheel”.

Dashboards should be both fast and beautiful, we get it, so we’ve brought Job Monitoring and Job Performance Analytics to Canvas Dashboards.

Now you can spot the slowest reports in your workspace, see which Canvas dashboards are dragging their feet, check if your Holistics Job Workers are overwhelmed, and make necessary optimizations to ensure your dashboards are fast enough to actually be admired.

If you have any questions, please let us know in this Community Post.


Tired of scrolling to check if your filters are mapped to the right report’s fields? We’ve got your back! We’ve added a nifty count indicator to show you at a glance how many reports are mapped.

pin to homepage

TL;DR: Your dashboards open faster now.

We’ve made another round of improvements to how fast dashboards open in Holistics. Now, from the moment you click a link until all the widgets pop up (minus the result data), everything moves quicker.

If you're into the nitty-gritty details of the optimizations we’ve made, check out this community post.


Now you can pin important dashboards to everyone's homepage. A small feature but it makes everyone's life a lot simpler. No more digging through layers of menus or searching endlessly!

pin to homepage

P/s: This is especially handy when your boss wants to rub it in everyone's face that revenue is tanking, and everyone needs to work ridiculously harder.

Just rename your Revenue dashboard to 'The Ship is Sinking' and pin it to the homepage for maximum impact!


As data usage increases, analysts often take on the responsibility of maintaining, debugging, and optimizing data resources. To support their efforts, we now make Job Monitoring available to Analysts, not just Admins.

job monitoring for data analyst

We made it easier to find the right fields by providing more information about hidden ones in the Dataset View List.

Better dataset view UX

Adding a Condition when exploring is much easier thanks to:

  • A new “Used in this report” section, containing selected fields for quicker selection.
  • Or you can just click this shortcut & add directly from the field list.
UX Condition Group

With Canvas Dashboard, you turn data into narratives. Now you can share them with the world - your favorite data delivery features are coming to Canvas Dashboard, including Export, Data Alerts, Sharable Links, and Embedded Analytics.

  • Export: Download your dashboard as PNG, PDF, or Excel.
  • Data Alerts: Send notifications to your team when certain conditions are met.
  • Shareable links: Create and share customized, password-protected links.
  • Embedded Analytics: Embed your stunning dashboard in your web apps.

Canvas Dashboard Delivery

info

💡 Canvas Dashboard is in Beta! To get access, register your interest here: Canvas Dashboard Early Interest Form


With our new Custom Persistence DDL feature, you can declare the custom_ddl for a Persistence, and customize how the persistence table is created in your Data Warehouse.

This allows you to apply Data Warehouse optimization features and techniques - such as indexing, clustering, applying SORTKEY, etc. - to improve the performance of your physically persisted tables!

Custom DDL

You can learn about this feature in our docs here: Public Docs | Custom DDL.

If you have any feedback or questions, please share them on this Community Thread.


Customers are churning, your org is bleeding money, and no one knows because no one can stand it when every spin of wheel feels like an eternity. Don’t you just hate that?

We know. This is why we just supercharged our Retention Heatmap to load 3x faster! Take it for a spin, and see how you enjoy our lightning-speed rows & columns!

faster heatmap

Table and Pivot table are not the only visualizations to get a speed boost here.

We promised a faster Metric Sheet, and we delivered. Metric sheet is now x4 faster!

faster metric sheet

You can now resize columns in the Pivot table, by simply dragging the right border of the header. And to make the column fit perfectly with its content, just double-click on that border.

faster metric sheet

At 9 a.m., one of your marketing executives opens Holistics for their daily data browsing.

They spot some new marketing dashboards. Excited to see what’s what, they open them all. They then get caught up in urgent marketing tasks, so before they can do any insight digging, they turn back, and exit.

Unbeknownst to them, the job triggered during their initial visit keeps running in the background, hogging a Job Worker, and blocking it from being used for more pressing reports.

To solve this, we proudly introduce 🤖 Auto Cancellation for Unused Jobs.

This feature allows you to set a timeout (e.g. 3 seconds), and any lingering job gets axed, automatically, freeing the Job Worker for other important tasks!

How do you see this feature being useful to your team? If you have any feedback or suggestions for us, please share them here. We’re all ears!


With Canvas Dashboard, you can easily freeform your layout - toss and shuffle visualizations, filters, text on a blank canvas however you like.

Yet, free form often comes with alignment. Having the freedom to place things anywhere can lead to a bit of a mess.

This is why we’ve added handy guides for block alignment in the Canvas Dashboard. You can now drag and drop, freely, without stressing about getting everything lined up just right. (See demo)


You can now customize the line style of your charts. Choose from style options like solid, dotted, or dashed; then choose from linear, smooth, or step-line interpolation for more variety of data representation.

A good chart is a chart with great visual clarity. And this little feature hopefully helps analysts get closer to creating one.


Open the latest changes in a flash! We’ve made it easier to open files from the most recent commit in your history


We’ve revamped the AML default page with the new workflow graphic and clearer wording to create a much smoother onboarding experience.


We are thrilled to introduce Version Restore - a new feature that lets you restore Holistics projects to any version!

Ever found yourself in these situations?

  • You’re diving into Holistics, changing stuff to see what’s what. Suddenly, you changed something which broke some other things, and you wish you could hit an “undo” button.
  • Knowing there’s no “oops” button, you tread so lightly you barely explore Holistics. Where’s the fun in that?
  • You decide to try out new ways of building metrics or modeling data. But things go sideways, and the only way back is a bunch of complex git commands.

Version Restore can help you avoid these situations. Roll back your Holistics project to any version you want, making exploration and innovation super easy.

Here’s how it works:

For more information, check out our public docs: Public Docs | Version Restore


We're excited to announce Condition Group, one of our most requested features, is now available. This new addition allows you to create complex filtering conditions instead of just AND-ing everything. Here’s what the feature brings:

  • Create OR conditions between different fields.
  • Group conditions together and create groups within groups.
  • Set AND/OR relationships between conditions.

For more information, visit our Public Docs: Filter with Condition Group.

Now before you dive into using the Condition Group feature, kindly note that:

  • Version 4.0 Required: If your team is still on version 3.0, you'll need to switch to version 4.0 to access this feature. You can find how to upgrade here.
  • Enable AQL: With version 4.0, make sure that you have activated our Analytics Query Language (AQL). For more information and to join our AQL beta, click here.
  • AQL-engine Dataset: Right now, the Condition Group only works with datasets that use the AQL engine. Learn how to set it up here.

Condition Group is currently limited to the Report level only. We're exploring potential uses and solutions for bringing this to Dashboards.


Another UX update to make your experience with Holistics a lot more delightful. New hotkey alert: Press Ctrl + \ (Windows) or Cmd + \ (Mac) to toggle the Holistics sidebar.


You can now resize the width of table columns. This change is temporary, and doesn’t affect the default width of the column. You can also bring it back to default width by double-clicking on the resize hover


Continuing our commitment to improving Holistics performance, we proudly introduce Job Performance Analytics Dashboard.

With Job Performance Analytics, you can:

  • Pinpoint the slowest reports within your workspace.
  • Identify which dashboards aren’t running as fast as they could be.
  • Monitor and check if your Holistics Job Workers are overloaded or not.
  • Monitor your Dashboards’ performance after making optimizations to your SQLs or Data Warehouse.

To get access to the Closed Beta, sign up here: Job Performance Analytics Early Interest Form.
If you have any feedback or suggestions for us, we’d also love to hear. See Community Thread here.


We’ve recently released an improved version of our dashboard data drills, where you can add multiple date drills to your widgets. The results also persist in export and schedule.


Our new table improvements have made rendering speed 3x faster compared to the previous version. In addition, we've made scrolling smoother, reduced popover load times, and more.

Check out this video to see the new Table in action:

Please note that this speed upgrade is all about visualization rendering. It doesn't affect query speed. Though, please rest assured we are working constantly to cover that, too!

P.S. We are working on similar upgrades for our Pivot table visualization, also. So please stay tuned!


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

For more information, check out our docs here.


Freeform layout is the most exciting feature in our upcoming Dashboard As-Code: You can drag-and-drop charts around to create space for context, give explanations, structure a business-friendly narrative, answer audience questions before they ask them, and build dashboards that spark stories, not boredom.

Better yet, everything on the dashboard is customizable using either a GUI or a Code-based Editor. The possibilities are abundant. You can turn it into a landing page, a Notion page, or any type of consumption interface that’s friendly to your viewers, and make it explorable with PoP or Data Drill, both of which were recently added to our Dashboards As Code.

How do you see this feature being useful to your team? If you have any feedback or suggestions for us, please share them here. We’re all ears.


Timezone is annoying. You can create the best dashboard in the world, but it won’t be really useful when timezone conflicts hit. Luckily, you’ll soon have a simpler way to manage your dashboard timezone, ensuring accurate data delivery to your customers.

With this feature, you can:

  • Set a default option if your viewers are in the same timezone. OR
  • Allow viewers to change to the timezone they prefer.

For more details, you can check out our public docs here


They say “All roads lead to Rome”, we say “But some are faster than others”.

There are many ways to get on with Holistics 4.0, and we want to bring you on the quickest path. In October, we introduced an upgraded flow to help your onboarding experience with 4.0 as effortlessly as possible. You’ll be guided throughout the whole process - from your first data source connection to your first datasets, and to your first report.

You can just follow the flow, click, clack, sit back, and relax.


On Oct 12, we released Lazy-rendering Widgets, as part of our effort to further improve Holistics dashboard performance.

Lazy-rendering make sures that all widgets are executed when the dashboard is opened, but only those currently in the viewport are actually rendered. As a result, the initial loading of each dashboard becomes significantly faster and more responsive.

In contrast, without lazy-rendering, every widget would execute and render as soon as the dashboards are opened, resulting in an accumulation of widget renderings and causing the browser to become sluggish.

And because actions speak louder than words, let's go through a quick demo here. :)

In the below demo videos, we're using a dashboard with 20 Pivot Tables.

Before Lazy Rendering

It took nearly 10 seconds for the Dashboard to be responsive. This gets worse as the total number of widgets in the Dashboard goes up.

After Lazy Rendering

It took 1-2 seconds for the Dashboard to be responsive!

More performance optimizations and features are on the way! If you have any questions or feedback for this functionality, feel free to share it here.


In October, we're making some great updates to our Dashboards As Code, making it easier to build reports using code and have fine-grained control over viz, layout, content, and reporting architecture.

We started testing this internally this month and can't wait to share with you a short demo - but before we get to it, here's a peek at how our data team has been using it:

Triet Le (Analytics Engineer): “I can code the entire dashboard into a narrative that people want to read and engage with.”

Huong Le (Data Analyst): “It becomes a lot easier to reuse a dashboard. I just need to clone it, change filters, change dimensions, and re-format it on the fly.”

With this feature, analysts will soon be able to adopt software best practices in your dashboard development. Through codification, you can have full control over the content and design of your dashboards, easily revert changes, make bulk updates, and have customized and reusable visualizations everywhere.

If you’re as excited as we are, stay tuned. We’re running as fast as we can to get this on your hands! :) Without further ado, here’s the new demo.

How do you see this feature being useful to your team? If you have any feedback or suggestions for us, please share them here. We’re all ears.

P/s: We had a lot of fun testing this feature. Our team was even able to whip up a Pokedex dashboard in just a few minutes.


“What is this dataset about? How should I use it? Who can I contact to learn more about using this dataset?”

Sounds familiar? Business users need to really understand a dataset to self-serve effectively. This is why how you present a dataset is as important as how you design it.

From now on, you can write markdowns to add Descriptions to your dataset, making it easier for business users to navigate and explore the data you’ve prepared.

Have any feedback or questions? Share it here with us.


We believe that data should inform action and the faster you can act, the better. This is exactly why we are working on Webhook for Data Alert - a major upgrade to Holistics Delivery capability.

With this, you can quickly set up automated workflows for critical internal communication, like:

  • Sending alert messages to the Purchasing team’s Telegram when inventory runs low, or
  • Buzzing the marketing team on Slack when ad spending goes over the limit.

We value your feedback, so please don't hesitate to share your thoughts and suggestions.


Our PoP has been a hit with our users because it takes just 03 clicks to uncover data trends over time - but things got a lot more laborious when you want to compare:

  • Sales numbers for 'Black Friday' season this year vs. the previous year, or
  • The number of registrations for an upcoming webinar vs. a previous webinar from six months ago.

The problem? Two arbitrary time periods. Different start dates. Different end dates.

🥁🥁 Glad to share that this is a problem of the past! With our newly released Custom Period, you can easily select any date range for Period-over-Period comparison.

If you have any feedback for us, we're all ears.


What makes a good coding IDE? Among other things, it helps you spend as little time on troubleshooting as possible.

With Reporting Validation, you take the guesswork out of your modeling workflow. Holistics IDE now tells you exactly which reporting items are broken due to Modeling changes - before you roll out these changes and lets you patch up all those broken reporting items swiftly and en masse.

P/s: We’re always excited to ship new features, but we’re way more excited when we get to build things that you all have asked us for. Take this new feature for a spin, and keep the feedback coming.


We have released a new option in Single-select List filter settings, where you can allow your dashboard viewers to leave the value field empty.

With this feature active, an empty value can be used without the need to apply the filter. We believe this change offers more flexibility and command over your filtering choices

We value your feedback, so please don't hesitate to share your thoughts and suggestions with us.


Query Timeout helps you abort any query that exceeds your timeout limit and takes too much time and resources.

However, previously in Holistics, the Query Timeout setting was only available for Postgres, Redshift, and MySQL databases. Understanding the importance of resource optimization - especially in our current economic climate - we’ve gradually expanded our support for Query Timeout in most SQL databases - making it also available for BigQuery, Snowflake, Microsoft SQL Server, ClickHouse, and AWS Athena.

Learn more here.

If you have any feedback for us, we're all ears.


We totally get it - feels like time's standing still when you wait for a dashboard to load.

We hate the loading screen as much as you do so we’ve been rolling out a new API - Dashboard Preload API - to help you preload the cache of your most frequently used or operationally critical views of your Dashboards so that they can be loaded in an instant.

This means no waiting time - not even enough for a quick coffee break :) Learn more here.

What do you think? Feel free to share your feedback and suggestions here, we'd really appreciate it.


Period Comparison was a hit with a lot of our users as it allows anyone to get insights into how data fluctuate over time. However, previously in Holistics, Period Comparison could only be set up by data analysts. Viewers don’t have the option to turn it on/off freely.

Recognizing the inconvenience and the growing demands for a more unified experience, we took a step forward: Period Comparison is now available at the dashboard level.

Dashboard explorers can now choose to apply the same comparison to numerous widgets within a dashboard and get a bird-eye view into how multiple metrics are changing over time.

What do you think? Feel free to share your feedback and suggestions here, we'd really appreciate it.


Is there a way to customize what fields in the model and dataset are being shown to end users for self-serve exploration? Otherwise, my users are overwhelmed by the sheer amount of fields available.”

Yes, we heard you. Introducing dataset views, where you can curate exactly what the end users will see.

This feature is now immediately available to all 4.0 customers. Learn more here.


What makes a good coding IDE? Among other things, it should tell you where your code got wrong, and how to fix them.

Well, we just made our coding IDE a little better: When doing analytics development, Holistics IDE now tells you where your modeling code is broken, and what exactly is wrong with them.

If you have any feedback for us, we're all ears.


Say goodbye to maintaining dashboards with only gut feeling - Because Holistics just released the BI equivalent of God-eye from Fast and Furious 07.

This feature gives admins a bird-eye view of dashboard usage & user activity, making it a lot easier to understand how your dashboards are being used.

Dashboard maintenance will be much less painful when you know precisely which dashboards are used by whom and how often.

In this official launch, we’ve released a plethora of upgrades to our Usage Monitoring - including Lists of dashboards with no view, Tracking of Private Dashboards, Performance improvements, and many more…

You can read more about it here: 🎬 Usage Monitoring: Beta Program Ending & Official Release | Holistics Community


With Dashboard Metadata, you can quickly glance over the dashboard descriptions and know who made it, when the last edit was made, or who frequent viewers are, and more. We hope this will help you foster better cross-functional collaboration by providing more visibility into how your organization creates and shares reports.

Your can learn more about this feature here: Dashboard Metadata | Holistics Docs, or share your feedback with us in our community post.


Holistics now allows pasting a list of CSV values directly from clipboard into the filters. This seemingly small upgrade is much requested by our users. Small details matter.

How does this small feature help?

  • Marketing sent you a CSV with email addresses, asking to see if any of them has made a purchase? Open Holistics reports, copy, paste.
  • Ops need to double checking a list of order IDs to see if they’re all delivered? Simply paste the list of IDs in the right report.

Learn more here: Mass input a list of values for Filter & Condition


AQL Expression is the next-gen upgrade to our current Business Calculation mechanism, designed to give you a more powerful and flexible way of querying data for various analytics purposes, including but not limited to:

  • Cross-model Calculation - Perform calculations across multiple models without having to manually merge the data via SQL Model.
  • Nested Aggregation - Create more complex calculations by nesting functions and aggregations within each other.
  • Add Filtering in an AQL Expression - Filter your data at the query level rather than having to do it in a separate step.
  • Support Date/Time Intelligence Functions - Analyze your data over time using powerful date/time intelligence functions.
  • Subgroup Calculation - Perform calculations on subgroups of your data without having to create a separate query for each subgroup.
And so much more! To illustrate AQL’s capabilities, let’s go over these 02 examples: Sub-group Calculation, and Cross-model Calculation.

01. Cross-model Calculation

Let’s say you are a Country Manager of an Ecommerce Company and you want to calculate the Revenue by Country.

The formula to calculate it is the sum of the product price (from the Product model) multiplied by the quantity (from the Order Items model).

They are from 2 different models so you can write an AQL expression like the video below

Sample syntax

sum(order_items.quantity) * 1.0 /
eval(sum(order_items.quantity),exclude(users.age_group))

02. Sub-group Calculation

With AQL Expression, you can perform Subgroup Calculations flexibly and easily without having to create SQL (or transform) Models.

Here's the sample syntax:

sum(order_items.quantity) * 1.0 / 
eval(sum(order_items.quantity), exclude(users.age_group))

Learn more here: [Upcoming] Our brand new Analytics Query Language, AQL!


Holistics is currently working on a significant improvement to our Modeling layer called Dynamic Models (feature request). This feature allows analysts to define reports that can take user inputs, and inject them directly into a model/report definition.

This feature is currently under development and is expected to be released in beta end of Q2 2023. Once released, it will only be available in Holistics 4.0.

How it works:

  • A new concept is introduced, called “dynamic model” — a data model that can take in parameters and will only be resolved in real-time.
  • Analysts can create reports from dynamic models
  • When a dynamic model is used in a report, end users can input values that feed directly into the model’s parameters

One of our latest developments is Date Parameter which will be available in our upcoming beta release. To create a Date Param and use it in the SQL definition of a Query Model, you just need 02 steps:

  1. Define the Date Param
param created_at_param {
label: 'Created At Param'
type: 'datetime'
}
  1. Use the Date Param in your SQL definition
SELECT ...
FROM ...
WHERE {%filter(created_at_param) %} date_column {%end %}

That’s it. And it’ll look like this in action. (You can also watch the video version here).

Learn more here: Upcoming Launch: Dynamic Models (aka Query Parameters)


Imagine running a marathon in flip-flops. It can be done - but at what cost?

An efficient keyboard is like a pair of top-notch running shoes - it just makes the journey more bearable, especially when you're sprinting through heaps of data. This is why we’ll be introducing a new array of exciting features to help you keyboard-sprinting through data - instead of flip-flopping through it :)

We’ll be rolling out the following features:

  • 🎨 Command Palette
  • 🔄 Unified Command Palette & Search experience

If you have any feedback for us, feel free to share it here.


The highly-requested Relationship Diagram for Holistics As-code (Holistics 4.0) is finally here.

Going forward, you have the option to work with your relationships in the Diagram view beside the usual List view.

(It's like choosing between a hearty medium-rare steak and a creamy and cheerful lemon cheesecake - having one is good, but having both is even better!)

Learn more here: Launch: Relationship Diagram for Holistics As-Code


We're glad to announce that we have recently achieved Select Tier partner status as part of the Snowflake Partner Network, solidifying our robust relationship with Snowflake and reaffirming Holistics’ commitment to data cloud’s best practices for product integration.

We hope that with this partnership, Holistics customers continue to derive greater value from data by enabling your entire organization to easily access, explore, and visualize data - enabled by Holistics’s self-service functionalities on top of Snowflake’s fast, flexible, and scalable data platform.

Read our full announcement here: Press Release: Holistics Achieved Select Tier Partner Status with Snowflake


With the latest search improvements, you're now able to experience:

  • Improved Search Algorithms: Our revamped search algorithms are now more powerful - delivering results that are ranked and grouped by similarity to help you quickly find what you’re looking for.
  • Simplified hotkey: With the simpler hotkey - Ctrl/Cmd + K, you can access the search feature from anywhere in Holistics.
  • Informative descriptions: To help you choose the right dashboard or widget, we have included descriptions directly in the search results.
  • Built-in filters: Easily narrow down your search results with our built-in filters, which allow you to select from a variety of categories such as Dashboard, Report/Widget, Folder, and Dataset.

If you have any feedback or suggestions for us, we're all ears!


The new My Account users allow Holistics users to manage personal information - making it easy for you to connect with other users on the platform.

You can spruce up your profile photo using Gravatar, and add your name, job title, and department, easily update your password to keep your account secure. If you need access to the Holistics API, you can also find your API key on this page.

Learn more here: User Profile


AML Studio is getting a fresh UI update that's gonna make things a lot clearer for users.

With the new update, you will have a much easier time telling which mode - Production Mode or Development Mode - they're in. Less error-prone, more intuitive for everyone.


Sometimes, Holistics' default visualization types may not be enough for your business needs. You may want to use charts that we do not support yet, or create a more customized chart type with modifications specific to your organization. The Custom Chart feature is, therefore, introduced to help you create custom, reusable chart templates that accommodate your needs.

Custom Charts are user-defined chart templates written using Holistics and Vega-lite syntax. Once created, it is available to everyone in your organization to use. The creation of a Custom Chart typically follows these steps:

  • An Admin creates the chart definition.
  • Other users within the organization can select the new chart type to build reports.

Check out our full tutorial here.


Sankey Chart is a type of visualization that represents the movement of data from one entity to another. Whether your marketing team wants to know how users move from one page to another and where they drop off.

Or your management team wants a visualization of how the budget is allocated across different departments or projects. Sankey Chart can get it.

And we’re proud to share that now you can create a Sankey diagram in Holistics - via our Custom Charts feature! Check our release note here for more details: Launched: Sankey diagram in Custom Charts | Holistics Community.


This comprehensive package offers full configuration for data alerts related to specific data events, including:

  • CRUD data alerts
  • Submit test data alerts
  • Immediate data alerts triggering

For additional information, please see our community post here: Launched: Data Alert API Package