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


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.



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:


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.


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. 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.



  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.


Happy Holidays!

New map chart options to control initial zoom

The map chart has a few new options that allow you to control the initial zoom / boundaries the map displays:

  • fix the map zoom to a specific area or (previous functionality) as a bounding box for the data
  • set minimum and maximum zoom the map would display


Parametrised SQL snippets and snippets-within-snippets

The SQL snippets now allow defining parameters, to increase the flexibility of what a snippet can do. And snippets can now be used within other snippets to be able to assemble higher-level snippets from lower-level building blocks.


See the docs here: basics and and parametrised

New Chart type: Histogram

We have added a brand new type to the stable of charts available as visualizations in Cluvio: Histogram chart. This is the first new chart type in a set of new types of charts we are working on, more will be coming over the next few months.


The Histogram chart looks similar to a Bar chart, but the purpose and the underlying behavior is more specific. Histogram chart represents a distribution of frequencies of values within a data set; imagine, for example, a distribution of ages within users or (as the image above shows) distribution of comments on posts by the comment length.

You can find out more about how to use the chart in the docs over here:

Added ability to configure text size for Pie, Bar, Line and XY charts

We added the ability to use larger fonts for Pie, Bar, Line and XY charts, with the same S/M/L/XL options as the Table and Pivot charts.

With the new option it is possible to create consistent-looking dashboards to use in cases where larger and more readable texts are displayed.