Skip to main content

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.