Announcing Imply 2.2: Pivot Features Galore

by Vadim Ogievetsky · in Imply platform · May 16, 2017

Imply 2.2 adds new Pivot features that enhance filtering flexibility, especially for time filters, new percent of total measures, and tuning for approximate quantiles. Check out the screenshots below that show these new Pivot features in action.

Adding filters from the filter bar

You can now add filters directly from the filter bar.

Cube view filter add

This is particularly useful in interactive collections, where you can now add arbitrary filters.

Dashboard filter add

Precise time picking

We have upgraded the Pivot time filter menu to allow you to select a precise time.

Cube view filter time-type-specific

You can now also select several time ranges.

Cube view filter time-type-multi

Percent of total measures

You can now configure measures that are defined as a percentage of their next higher split (or of the global total).

Data cube edit percent of total

This in effect transforms the measures on the client side.

Data cube percent of total

Tunable approximate quantiles

It is now possible to fine-tune approximateHistogram based quantiles, allowing you to determine your trade-off between performance and accuracy.

Enter a 3rd parameter in the quantile formula of the form 'resolution=400,numBuckets=10,lowerLimit=0,upperLimit=1000' to pass those tuning parameters to the underlying aggregator.

Data cube edit tune quantile

To understand how to tune the approximateHistogram parameters check out the Druid documentation

Query monitoring

Have you ever wondered what queries are being issued under the hood as you fly around your data? While it was been possible to run Pivot in verbose mode since the first release you can now inspect your queries directly from the UI.

monitor queries

The query view is a great way to understand how Pivot interacts with Druid in particular if you are utilizing custom transformations or custom aggregations.

Other improvements

In addition to all of the above we also improved the consistency of some Pivot workflows as well as greatly reducing the number of queries that Pivot will issue to Druid.

And my favourite tiny feature in this release: the titles of the browser tabs will now show the names of the data cubes and collections.

Pivot tabs

Hope you enjoy.

Getting started

You can get the latest version of Imply on our download page. To learn more, please see our documentation. Any feedback, bug reports and feature requests are always welcome - you can post them in our user group or contact us.

Back to blog

How can we help?