Skip to main content

Release Notes

Follow us on X to stay up-to-date with new releases!

๐Ÿ“ Exporting an entire dashboard directly to Excel

You can now export entire dashboards directly to Excel! ๐ŸŽ‰

This update is designed to saves you time and effort, letting you download your dashboard as a single Excel file in just a few clicks.

โœจ New Styling Options for KPI Metric

Level Up Your KPIs with New Styling Options โœจ ๐ŸŒŸ ๐Ÿ˜

With our new styling options, you are now empowered to make your KPIs more visually impactful. Adjust font size, font color, text alignment, and explore unique styles for each comparison type ๐Ÿ™Œ

Ready to give your KPI Metrics a dazzling makeover? Share your styling creations with us! โœจ๐ŸŽ‰

๐Ÿงจ Change Dimension/Metric via Dashboard Filter (by using AQL and Query Parameters)

Introductionโ€‹

AQL is getting an upgrade! No more static calculations. You can now make AQL dynamic by combining it with Query Parameters.

This means AQL definitions can adjust based on user inputs via the Dashboard Filter, and you'll be able to do Dynamic fields selection (dynamic dimensions, dynamic metrics)

Demoโ€‹

Dynamic Dimensions Selectionโ€‹

Dynamic Metrics Selectionโ€‹

More details on how to set upโ€‹

If you want to understand more details on how to set up this, please refer to our doc about Advanced Use Cases

๐Ÿ’ฅ New Resolving Conflicts Flow

Say goodbye to the hassle of manually resolving merge conflicts!

Weโ€™re thrilled to introduce the Quick Resolve option, which allows you to:

  • Instantly choose whether to keep your version, or the incoming version for each conflicted file.
  • Apply your choice to all files at once, so you can quickly return to your tasks.

For those who prefer a more hands-on approach, the Manual Resolve option remains available, letting you sort out the conflict in the code editor.

Check it out in action:

๐ŸŽ‰ Enhanced Table Interactions

Weโ€™ve made working with tables easier and more intuitive! With these updates, you can now:

  • Change aggregations and time grains
  • Auto-size columns
  • Rename columns
  • Remove columns

All directly on your tables, giving you more control and flexibility in your workflow.

Give it a try and let us know what you think! ๐Ÿ˜Š

๐Ÿ” Two-factor Authentication (2FA)

Holistics now supports two-factor authentication (2FA) for password-based login.

Two-factor authentication (2FA) adds an extra layer of security to your Holistics account. Once enabled, it requires an additional code from an authenticator app (e.g., Authy, Google Authenticator, etc.) along with your email and password, ensuring only you can access your account.

The admin can require two-factor authentication for all users to enhance the organizationโ€™s security.

To learn more, please go toย Two-factor Authentication for detailed settings.

โฐ Extract date parts from dates

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:

โบ๏ธ Toggle to turn on โ€œMerge into one lineโ€ for trend lines and reference lines

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:

๐Ÿงฉ Validate Project with Validation API and GitHub Action

The Validation API allows you to validate your projects outside of Holistics, enabling smooth integration with CI/CD workflows. This feature is particularly useful in scenarios such as:

  • Validating updates before merging a pull request into the master branch by incorporating the Validation API within the CI/CD pipeline.
  • Validating changes immediately after updates are pushed to the master branch.
  • Running validations prior to using the Publish API to ensure a successful publish.

๐Ÿ”˜ Toggle to turn off โ€œBreak down by legendโ€ for individual measures

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.