Release Notes

• Jun 08, 2018

  New Feature: Sorting for Visualization

  We now support sorting for visualization. You can sort your line, column, bar, area, pie, funnel and pyramid charts!

  
  

• Jun 08, 2018

  New Feature: Support SSL for MongoDB

  Now you can connect your MongoDB server to Holistics with SSL!

  

• Jun 04, 2018

  New Feature: Conditional Formatting

  This feature allows you to specify customized cell colors based on cell values.
  Now you can quickly highlight important information in your report!

  
  

• May 25, 2018

  New Feature: Drilldown in Embedded Analytics

  Gain deeper insights with the combination of Drilldowns and Embedded Analytics!

  This lets you drill into the details of your data reports with one click, to pull up a more detailed dashboard/report from your embedded analytics. Now your customers can access deeper analytics from right inside your own application, to explore finer levels of data analysis of your business questions!
  
  

• May 15, 2018

  New Feature: Version Control for Report

  We now support version control for reports. Now you track changes of your report and revert to its previous version. This includes restoring report's query, filters and visualization settings.
  
  

• May 11, 2018

  New Feature: Support Else Syntax for Filter Permission

  We now support else syntax in filter permission!
  This is useful, for example, when you want the filter to return a value for anyone who does not belong to its above condition.
  

  Please refer this docs on how to to this.

  One of the feature's use cases includes the ability to Hide/Show Columns in a Report based on User Permission. Please refer this blog post on how to do it.

  

• May 10, 2018

  New Feature: Support Variable in Email Schedule

  We now support adding 2 variables {{$today}}, {{$yesterday}} in an email schedule's body and subject!

  Example: A subject/body that has Sales report for {{$today}} will become Sales report for 2018-05-10 Tue when it is sent.

• May 08, 2018

  New Feature: Set timeout in data source

  We now support setting timeout for your query in PostgreSQL and Amazon Redshift! Queries running on that data sources will be killed after your set runtime.
  
  

• Apr 25, 2018

  New Feature: Drag and Drop in Explorer (Left Sidebar)

  We now support drag and drop in your explorer! You can move them with ease!
  
  

• Apr 19, 2018

  New Feature: Automated Reverse Tunnel

  With our new automated reverse tunnel script, connecting to data sources in your private network is easier than ever! Learn more here.

• Apr 09, 2018

  New Feature: Export Notifications

  No more waiting for annoying export dialogs.
  Your export jobs are now listed in your notifications, so that you can make and track multiple exports more conveniently!

• Apr 05, 2018

  New Feature: Move Dashboards in Report Explorer

  You can now move your dashboard around your hierarchy like what you can do with reports!
  
  

  

• Apr 01, 2018

  New Feature: Clone Widgets

  You can now clone widget in your dashboard! This makes adding new widget really fast.
  
  

• Mar 28, 2018

  New Feature: Drag and Drop in Dashboard

  You can now drag and drop widgets in your dashboard!
  
  

• Mar 23, 2018

  New Feature: Pause Schedule

  We now support pausing for schedule!

  You can pause and resume execution of schedules (Schedule data export to Slack, Email and Data Report Cache).

• Mar 12, 2018

  New Feature: Mobile Responsive View

  Access your data outputs easily, on the go! Holistics dashboards are now optimized for mobile viewing.

• Mar 08, 2018

  New Feature: Google Sheet Schedules

  Holistics now support making schedules that export your report data to google sheets.

• Feb 01, 2018

  New Feature: Pivoting Report Results

  We now support users to explore/pivot the report resultset directly. So that user can further aggregate data of a report table.

• Jan 16, 2018

  New Feature: Slack Schedules

  Introducing a new type of schedule which allow sending reports to your Slack workspace. See this documentation to get started.

• Jan 15, 2018

  Change: Dynamic Shareable Links

  Users now can make filters in shareable links editable. This allows viewers to process the report with their accessible data.

• Jan 05, 2018

  Change: Users Now Can Create Report Widget Directly From Dashboard

  Users now don't need to create a report beforehand when they want to add a new widget to dashboard.

• Dec 12, 2017

  Change: Users Now Can Export Reports Directly

  Instead of user waiting for report to return results to export, now user can export report result directly, save them a lot of time waiting!

• Dec 05, 2017

  Change: Option When Creating Table in Data Transform

  We added a new option in data transform, where you can specify an extra option to customize for table creation.

  This is useful, for example, when you want to set some other tablespace of your table:

  CREATE TABLE some_table(
    foo varchar,
    bar int
  ) TABLESPACE fast_sdd;
  

  

• Nov 30, 2017

  New Feature: Cohort Retention Supports Both Absolute and Percentage Values

  Cohort Retention provides you a toggle for you to switch between numerical and percentage display values based on the cohort size. It will automatically calculate percentage values based on Cohort Size rather than doing it manually via SQL.

  Learn More

• Oct 23, 2017

  New Feature: Export to Google Sheet

  
  We now support exporting data from a report to a Google Sheet. Learn More

• Oct 20, 2017

  New Feature: Report Explorer

  With the new Report Explorer panel, you can quickly view and switch between your reports and report categories

• Oct 20, 2017

  Change: Enhanced Query Editing Experience

  We greatly enhanced our query editing experience. Now you can see all your run queries, and pin them in the right panel.

• Oct 12, 2017

  New Feature: Support AWS Athena

  We now support AWS Athena source. You can now use SQL to analyze logs, and other files on your S3. Please see our setup guide.

• Oct 09, 2017

  Change: Holistics v2.0

  We just revamp Holistics navigation system including swift page transition, no page reload, and faster page load time.

• Sep 28, 2017

  New Feature: Upload CSV

  In additional to the CLI option, we now support uploading CSV directly from our webapp.

• Sep 14, 2017

  New Feature: Allow quick visualization of adhoc query results

  Along with table data, adhoc query results now can be displayed as charts for better data visualization.

• Sep 14, 2017

  New Feature: Scheduled caching

  We now support scheduling pre-caching of reports and dashboards. You can dramatically improve performance of your reports and dashboards view by adding scheduled caching before they are consumed.

  Learn More

• Sep 13, 2017

  Bug Fix: Fix corrupted Excel file when downloading report

  On Mac, when you download report Excel file, the file can be corrupted. The root cause is incorrect format style.

  This bug has been fixed. Excel download should work fine now.

• Sep 08, 2017

  New Feature: Data Manager

  We just released our new feature: Data Manager! You can now have an overview of all tables from your data sources. Learn More

• Aug 29, 2017

  New Feature: Import from specific Google worksheet

  You can now import from specific worksheet in Google Spreadsheet. You can select the appropriate worksheet in your Google Spreadsheet, then copy the URL. We will import from the worksheet specified in the URL.

• Aug 22, 2017

  New Feature: Support Pipedrive Data Source for Import

  We now support Pipedrive data source. You can create a new Pipedrive data source, then import data for Deals, Organizations, Persons, and Stages.

• Aug 22, 2017

  New Feature: Support Facebook Ads Data Source for Import

  We now support Facebook Ads data source. You can create a new Facebook Ads data source, then import data for Ad Campaigns, Ad Adsets, and Ads.

• Aug 11, 2017

  New Feature: Support Conversion Funnel Chart

  We now support Conversion Funnel Chart, a new visualization. It can help you measure and visualize the "conversion" rates between stages along the growth of a process. Learn more

• Aug 04, 2017

  New Feature: Support Hive on Qubole QDS

  We also released another new feature! Support Hive on Qubole for data reporting. View screenshot

  Learn more about Create database and Data Imports

• Aug 04, 2017

  New Feature: Support Oracle Database for Data Imports

  We just released our new feature! Support Oracle Database for Data Imports View screenshot

  Learn more about Create database and Data Imports

• Jul 31, 2017

  New Feature: Email Filter Permission

  The SQL filter permission now supports injecting the user email dynamically via $user.email variable.

  You can maintain your own user-permission table, Holistics will read from that table and generate the correct permission for each user based on their email.

  Read More

• Jul 27, 2017

  Change: Metric Widget Enhancement

  We just released some new options on metric widget in dashboards:

  • Support This quarter period
  • Allow hiding period comparison
  • Allow selecting period to compare with selected period

  View screenshot

• Jul 26, 2017

  Change: Cancel DataImport, EmailSchedule, DashboardWidget Jobs

  Along with QueryReport and DataTransform jobs, running DataImport, EmailSchedule, DashboardWidget jobs can now also be cancelled. Learn more

• Jul 09, 2017

  New Feature: Support Oracle Database

  We just released our new feature! Support Oracle database for data reporting. View screenshot

  Learn more about Create database

• Jul 07, 2017

  New Feature: Embedded Analytics

  We just released our new Embedded Analytics feature! This allows you to embed Holistics inside your web application, and display data to end-users based on their current ID (think applying organization_id = ? to their view).

  Learn more about Embedded Analytics.

• Jul 06, 2017

  Change: Adhoc Filter Support Previewing

  Adhoc filter can be previewed when being created or edited. View screenshot

• Jul 06, 2017

  Change: Parent-Child Filter Support Chaining

  We now support chaining effect for parent-child filters. Consider we have 3 filters: Region, Country and City with the relationship: Region --> Country --> City.

  When we set a new value for Region (e.g., Asia), available options for both Country and City filter will be updated based on the new region (can only select countries and cities in Asia).

  View screenshot

• Jul 04, 2017

  Change: Better Adding Report To Dashboard

  We improved the UI/UX of report widget dialog, so now adding a new report to dashboard is a much smoother experience. View screenshot

• Jun 28, 2017

  Change: Activity Log Management Has New Filters

  The new filters allow you to filter activities by actions, user, date and target, which is available at Activity Log Managament. View screenshot

• Jun 27, 2017

  Change: Improved UI Performance for Report Page

  You should notice a considerable increase in our Report UI performance! We've spent an incredible amount of efffort in making the page loads faster, the dropdown filter works faster for large list of items.

  Also, now switching between different filter values don't require a reload of page anymore!

• Jun 26, 2017

  Change: Support filtering for Embedded Dashboard

  Embedded Dashboards now support filtering. Embedded dashboard's owner can set default values for these filters (overriding shared filter's default value or not), and specify which ones are read-only.

• Jun 22, 2017

  Change: Dashboard Email Schedule Fail Fast

  Previously, when a widget (report or metric) of a dashboard failed, that widget would be omitted in the email content, the email was sent with the other working widgets.

  For this change, we will cancel the email sequence if any widget fails and notify the owner of the dashboard, so that he/she can login and repair the dashboard right away.

• Jun 18, 2017

  Bug Fix: Fix filter names using framework keywords

  Previously, when you name your filter names using some keywords like action, id, etc, this causes an error as it conflicts with the Rails (yes we use Rails) framework parameters.

  We have since fixed this, and now you can name your filter variables anyway you like.

• Jun 16, 2017

  New Feature: QDS Presto Now Supported In Data Import

  Qubole/QDS customers now can perform data imports to load data from multiple sources into their data warehouse.

• Jun 06, 2017

  New Feature: Metrics Spreadsheets

  We're excited to annouce we just released metrics spreadsheets. This allows you to build a perfect KPI spreadsheet for your management to monitor everyday.

  You can easily see your metrics by different time dimension, and compare it with previous time period. Learn More

• Jun 06, 2017

  New Feature: Support Detailed Row View

  In your report view page, we added support for detailed row view, you now can toggle this mode and see each record in a detailed table. Read more in our docs.

• May 31, 2017

  New Feature: Support for Geo Heatmap Chart

  We finally released Geographical Heatmap. Geo Heatmap Chart helps you visualize the interesting geographic points and their influence on a map. Learn more.

• May 16, 2017

  New Feature: Support Qubole QDS for Data Transform

  QDS customers now can perform data transform to pre-aggregate data for reporting.

• May 16, 2017

  New Feature: Add Annotations Support

  We finally released Annotations - now not only you can see your chart, but you can make sense of what's happening with it. Learn more

• May 11, 2017

  Change: Report Editor Has New Layout

  The new UI will focus on the SQL editor, as long as organizing sections on the report editor page in order to make this page cleaner and easy to use. View screenshot

For older release notes, you can access the old changelog page here.