Drill-down now available on Pie chart

The ability to drill-down is now also available for the Pie chart reports.

pie-chart-drilldown.png

Lots of improvement for the report editor

We have launched a set of improvements for the analyst experience in the report editor. These include:

  1. the Almanach sidebar can now be collapsed so you have more space for editing and chart configuration on smaller screens when the almanac is not needed

collapsed-sidebar.png

  1. Query history, which includes all the queries you executed in the past in the report editor for the currently selected datasource. You can use a full-text search to filter the results.

query-history.png

You can also easily diff the query to the current one or take over the query from the history:

query-diff.png

  1. Report history - when editing an existing report, the Report history displays all historical changes made to the report, together with who and when made the change and high-level overview of the changes. You can easily restore a past version or see a low-level diff of that change or diff to the current report configuration.

report-history-item.png

Use current date in dashboard schedule subject or body

A small improvement adds the ability to include current date in dashboard schedule emails - simply use {date} anywhere in the subject or body field and it will be replaced with the current date, formatted according to your organization preferences.

date-in-schedule.png

date-in-schedule-email.png

Sparkline mode for Line and Bar charts

A new setting for Bar and Line charts allows configuring the chart with minimal visual clutter and margins displayed, suitable for displaying as small charts that give further context to another metric or report.

sparklines.png

Smart color picker

We have improved the color picker used for assigning custom colors in charts or picking a color for conditional formatting.

The main improvements are:

  • a quick visual way to pick a color
  • smart automatic list of previously/frequently used colors - the color picker has a list of colors used on any of your reports, so reusing a common set of custom colors is fast and easy

color-picker.png

Conditional Formatting is here

We have launched a major new feature that adds Excel-style conditional formatting to Table, Pivot table and Number charts.

You can easily add one or more rules that apply formatting or add icons based on rules. The rules provide advanced conditions such as value, percents, or percentiles for numbers.

The formatting provides few useful presets, custom font styling and colors, and even allows applying a custom CSS string, so you have virtually limitless options for visually representing the conditions.

For more details about the functionality see the docs page here.

conditional-format-1.png

conditional-format-table.png

Use filter values in report title or description

You can now use the selected filter value(s) in a report title, description or custom "No data" message.

Having the report title set as

Airports in {selected_countries} ({result_rows})

Will render the report title like this when "Australia" and "New Zealand" are selected:

airports-in-australia-new-zealand.png

See the full docs here.

Dashboard schedules will now wait for data

We have improved the behavior of dashboard schedules for cases, where the queries take long to complete. The dashboard schedule will now wait for the dashboard to have all data available before sending out the emails.

In most cases, you will not see any change, but in case your database is overloaded or the queries take a long time to complete, the emails may be sent few minutes after the scheduled time, prioritizing showing meaningful data over being sent at the exact time.

Going all in on Dark mode!

Cluvio has had the support for dark mode for a few years now, initially for dashboards and later for all the user interface. The operating systems support for dark mode has been gradually getting better, with most major operating systems (MacOS Catalina, latest iOS, Windows 10) supporting it well now.

Today we are launching a set of features that further improve the dark mode behavior in several important ways:

1. Automatic switching of the dark mode

The new default user mode setting is "Auto", which displays light or dark mode based on the operating system setting. It will also dynamically change whenever that setting changes, so if the OS itself has the value set to Auto (e.g. MacOS Catalina), the OS and any open Cluvio dashboards would automatically switch to Dark mode in the evening and back to Light in the morning.

2020-03-05 17.21.57.gif

2. Dark mode support for PDF / Image rendering

When you download a report or dashboard as an image or PDF in dark mode, you will get the render in dark mode as well.

3. Dark mode support in e-mails (for real!)

All the emails we send are now optimized for dark mode, if the email client supports it. This includes all standard emails like password reset, user invite and also SQL alert emails and Dashboard Schedules.

IMG_1989.PNG

Foro Dashboard schedules, you can now choose to include light or dark mode images / PDF, in case you select both light and dark inline image, either the light or the dark image will be displayed to the user based on his own OS setting. This works in many email clients, but not all (Gmail is a notable example that does not support dark mode well yet, although they are reportedly rolling this out and it is already available to a small number of users).

Dark mode in emails is challenging, please let us know if you come across anything not working properly in your email clients!

4. Embedding. Cluvio embeds also support automatic dark mode in addition to the already existing light/dark mode, allowing to build web apps that themselves support the dark mode well.

When embedding, you can now choose the behavior to be:

  • light-only (default)
  • dark-only
  • light/dark based on your web app user's preference
  • light/dark based on the OS preference (i.e. full automatic)

Additionally, the initial loading screen background can be also controlled in the same way, giving the full user interface a fluid feel.

5. Cluvio.com website

Our website is also adjusted to support light and dark mode.

Dashboard groups and Favorites

We are launching a set of features that improve working with lots of dashboards.

dashboard-list-tiles.png

dashboard-list-boxes.png

  1. New way to represent dashboards as tiles with a thumbnail and improved visuals for the old "boxes" representation.

  2. Dashboard groups to organize dashboards by purpose

  3. Favorites that allow any user to select own set of frequently used dashboards; with one or more favorites, the Favorites group will open by default instead of the last accessed dashboard.

  4. Improved way to hide the initial sample dashboards without having to delete them.

You can read more in the docs here.

dashboards-uw.jpg

Happy Holidays!