To learn more about the latest updates about our product development, give feedback, and upvote for the features you would like to see in Holistics, please visit Holistics Community - Product Roadmap 👋

New Update:

• PoP for Data Tables and Pivot Tables (with an option to display % change)

• Running totals

• New improvements on dashboard styling

Bug fixes:

• Fix: Chart contrast and explore buttons position

New Features

• New Data Centers in EU and US

• Running Total (Sum, Avg, Min, Max)

Improvements

• Update analyst permission on shared datasets

• Automatically open link in new tabs

While 2021 is running to an end, Holistics is all about...Running Total!

Running Total is a very common calculation method that shows how a metric changes over time e.g. how the number of goods sold accumulates over months.

Previously, you could create Running Totals using our Transform Model (guide), though that requires some SQL knowledge. Now, with just a few clicks, you can immediately create a Running Total in visualization settings. Kabam!

In this version, we support 4 types of Running Total: Sum, Average, Min, and Max.

For more information, please visit our document.

New Use-case Supported:

Admin role now can allow Analyst role to explore and create reports from any datasets without granting them the access to Data Modeling Layer.

How to do:

• Step 1: Un-share the data source access to these Analysts

  

• Step 2: Share the dataset access to them only
  

New update on Analyst's Permission:

In brief, the Analyst's Permission will be changed as follows:

Before:

• If Admins share Data source access to Analysts, they will be:

  • Able to access and edit all child items as usual

  • Unable to edit the data source

• If Admins only share Dataset access to Analysts, they will be:

  • Able to access and explore reports from that dataset.

  • Unable to edit anything & create reports from that dataset

After:

• If Admins share Data source access to Analysts, they will be:

  • Able to access and edit all child items as usual

  • Unable to edit the data source

• If Admins only share Dataset access to Analysts, they will be:

  • Able to access, explore, and create/edit reports from that dataset.

  • Unable to edit the dataset and access higher-level items (data model, data source)

For more information, please visit our public doc here: Permission System | Holistics Docs

Your database often operates under a default timezone (normally UTC), but you will likely want every calculation or display to be in a different timezone.

Today, we are glad to introduce the beta version of our new Timezone Settings, a configuration that allows you to change the data-processing timezone.

For more information on this setting, please visit our public doc here: https://docs.holistics.io/docs/datetimes/timezones

If you find it interesting to join our beta test, do not hesitate to register here!

We are glad to announce that our team has already supported two new data centers in Europe and the United States of America.

For more information, you can read our public doc here: Holistics's servers | Holistics Docs

Please notice that the automated migration process is still under development. Thus, in case you find it interesting to switch to our new data center, you need to migrate your data from Singapore to the new one manually.

For more information on the migration process, please contact us via support@holistics.io.