Release Notes

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! 😊

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.

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:

• Extract date parts from dates

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:

• Trend Lines: Display one or multiple trend lines
• Reference Lines: Display one or multiple reference lines

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.

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.

Copying table values just got a lot easier. You can now right-click on any cell or range to quickly copy and paste values.

Plus, you have the option to choose between formatted (WYSIWYG) or raw values, giving you more control over your data. 🎉

Visit our public doc for more details: Data Table | Holistics Docs (4.0)

Following the success of the Hiding Columns feature in Table, we’re excited to announce a new enhancement: you can now hide Row Fields columns in Pivot Tables!

This update gives you even greater flexibility to customize and manage your data views, tailoring them to your specific needs.

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

Note:

• Currently, we only support hiding Row Field columns.
• 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.

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.