Bime 1.85: Data filters, Dynamic Count, Custom Display Formats [RELEASE]

Bime 1.85 is out with a new great new feature set. The most important are data filters in dashboards. It is only available in the Enterprise Plan, but as with every release, we've made improvements to as much of the service as possible. Here is an overview of the best new features.

Data Filters in dashboard

Until now, you were only able to filter the data already present in the different visualizations of a dashboard. At base, they were visual filters that would reduce the size of each result by removing, for example, Product A & B from the results. While that in itself was already super useful, with 1.85 you get a new powerful feature in your toolset: data filter prompts. With data filter prompts you can slice the whole dashboard data even with attributes not present in the query results.

This feature gives you a whole new level of interactivity in your dashboards. The ability to examine data from multiple perspectives in a single place allows you to discover even more of the meaningful relationships that exist in your data. The good news is that analysts can pursue an unlimited set of questions directly from the dashboard, leading to comprehensive and free-flowing exploration.

Data Visualization guru Stephen Few writes: “Comparison is the fundamental activity of analysis. Something powerful happens when we are able to see data simultaneously from several perspectives. We are able to spot connections and discern relationships that would otherwise remain hidden. If we were to look at these same views of the data independently, one at a time, we would never gain the same insights, largely due to the limits of short-term memory. Once one of these views is no longer in front of our eyes, we remember little, if anything, of what we saw, so we cannot compare it to what we’re looking at now. We can hold about four chunks of information at one time in short-term memory. One of the best ways to work around this limitation is to place everything that you wish to compare within eye span.” Enter Bime's Data Filter Prompt.

Here is an example of a dashboard that uses data filter prompts (on the right toolbox). User is "guest", password is "guest".

First tab in the right toolbox is data filter prompt. Second tab is visual filter.

How does it work?

When you create a dashboard (Pivot Table > Save to New Dashboard, "New" button in monitor) you now have three options:

1) Use query filters as prompts

This searches at every level in the pivot table filters dropbox in order to create prompts in the dashboard.

Example:

Query 1 from connection 1 has "Product" in the filters with no member selected.

Query 2 from connection 1 has "Product" in the filters with P1 member selected. Query 2 has also "Year" in the filter.

If one send these queries to a dashboard, we will get three prompts for data filtering: Product with nothing selected, Product with P1 selected, and Year. Changing these filters will affect only the original query of the prompt. A color legend is used to convey the link between the visualisation and the prompt.

2) Share filters between same connection queries

If option 2) is checked, filters from queries originating from a common connection will be mingled.

The same example as before will now give two prompts in the dashboard: "Product" with P1 selected by default and Year with nothing selected. Changing either of these prompts will modify query 1 & 2 in the dashboard.

3) Hide visual filter toolbox

Allows you to hide the original visual filter toolbox.

Note: you can modify these settings for an existing dashboard by choosing "Preferences" in the Dashbord menu (Monitor > blue arrow close to the dashboard name > Preferences).

Dynamic count

Sometimes, you just want to...count things. Every non-OLAP connection comes now with a new dynamic calculated measure called "Dynamic count" that allows you to count the number of rows in the orginal datasource that match your current query.

Custom display format

Until now, measure display formats were Bime ones. In this release, we've given you the ability to apply the display format of your choice: 2 digits precision, "," as decimal separator, $ in the end etc...

We hope you'll like this new release. Remember to use our support page to give us feedback and suggestions. Happy data analysis!