November 26, 2019

🗓 2019 November Updates

New features
- New Version of Dashboard
- Dynamic filter for Dataset-based reports
- Sub-total function for Pivot table
- Create Data Model from 3rd Party Sources

- Prevent Dataset's deletion when there is a report using it
- Prevent deletion data model when the already have dependencies
- Make the warning more transparent when there are too many columns pivoted
- Show error message when users do not have Google Analytics account
- Update new data source icon
- Improve Search Performance at IconService
- Show total rows/columns of Pivot in Excel export file
- Restrict users to disable Cache

Bugs Fixed
- Fix fields in the Data Model are still visible in Model Preview after being hidden
- Fix Drag & Drop bug in Data Set explore
- Fix: Pivot/Do not show Column/Row total if there is no row/column
- Fix cannot import MongoDB when the collection contains periods (.)
- Fix double click on measuring fields is not working in Data Model Preview
- Fix persistence status still displays 'Enabled' after saving the model with schematic changes

November 20, 2019

🎯 Total and Subtotal for Pivot Table

Holistics are glad to announce that we just released 'Total and subtotal for Pivot Table', which help you not manually calculate data or download data in Excel to conduct aggregate function.

To use Total functions, you just simply go to Pivot Table > click Style panel on Viz Settings > turn on/off total toggles.

We strongly believe that this feature will play an essential part in shortening your explore time and enhancing your effectiveness in manipulating insights.
For more information, please refer to our publics docs:

November 11, 2019

Create Data Model from 3rd Party Source

When modeling your data, sometimes you have other data sources such as Google Spreadsheet, Google Analytics or even a CSV. Normally you would require a custom ETL job to pull those data into tables in your data warehouse, and then you can create models on those tables.

With Holistics's Third-party Model feature, you can do everything in a single flow. Simply click Create -> Add Data Model from Other Sources -> Select a Third Party Source.

For more information, please refer to our public docs:

October 30, 2019

🗓 2019 October Updates

New features
- Allow users to quickly access Recent & Favorite Dashboards on Home screen.
- Allow users to check fail Job info for importing multiple data models.
- Support Conditional formatting for Boolean type.
- Support Grand total for Pivot Table.
- Introduce: Dynamic root Data Model Dataset

- Improved Search Experience on Mobile version.
- Improved Back Experience on Mobile version.
- Improved Chart Reset Zoom.
- Updated MongoDB connector to v2.10.2.
- Improve executed query tab in normal report, dataset, expanded widget.

Bugs Fixed
- Fixed: Cannot change Dataset Name.
- Fixed: Explore Dashboard's shared widget when source report is not shared.
- Fixed: Cannot move Data Model in/out folders.
- Fixed: Cannot run dashboard's email schedule when dashboard widget is removed.
- Fixed: Inconsistent data table display between report show and widget show.
- Fixed: Fail to export Pivot Table in Excel when Excel table includes null values in row cell.
- Fixed cannot rename chart/table when explore dataset
- Fixed cannot drill in Dataset-based reports
- Fixed cannot update Google Analytics Parameters in GA Data Import

October 13, 2019

🧭 New User Type: Explorer

Today, we officially release a new user type: explorer

Previously, Business Users (or Viewers) are unable to explore but only view the reports and dashboards that are shared with them. We totally understand that limitation so we have empowered you by adding another type of user (Explorer).
Explorers are able to explore datasets & reports and can save their exploration quickly and conveniently.

Refer to our docs for more information:

September 8, 2019

🗓 2019 September Updates

New Features
- Supported creating data model with import from PostgreSQL, MySQL, SQLServer, GoogleSheet, MongoDB, Pipedrive and BigQuery
- Supported binary type for query
- Show recent dashboards on Home screen
- Allow admin to restrict users to export data from Shareable links
- Allow admin to restrict business users to export data

- Removed Nested Relationships in Conditions, Fields and Preview
- Not allow pressing ESC to close Field/Measure Creation Modal
- Saved limit settings to report Viz settings
- Corrected suggest data types for SQL Server on Data Import
- Automatically normalized name for SQL Model Creation, Custom Expression Creation Connect and Data Source Creation page

Bugs Fixed
- Fixed Link styles & Table styles in Tools
- Fixed imported data model wrong source name
- Fix report created from personal folder saved wrong place
- Fix relative date filter preview showing wrong value due to timezone BETA