Cluvio updates
Cluvio updates
www.cluvio.com

Excel exports Info sheet and dashboards download as CSV (ZIP)

 

Feature

  

Ever opened an exported spreadsheet a week later and wondered which dashboard was this, with which filters, and how fresh is the data? Your exports now answer that themselves.

excel-info-sheet.png

Every Excel export - dashboard downloads, single-report downloads, scheduled e-mail attachments, and sharing-link downloads - starts with an Info worksheet that carries the full context:

  • What and where: the dashboard or report name, its description, and a clickable live link that reopens the exact view, with the export's filter values applied
  • Who and when: when the file was generated (in your dashboard's time zone and UTC) and by whom - a user, a public link, or a schedule
  • Which filters: every applied filter with human-readable values, the way they appear in the filter bar - How fresh: per-worksheet data timestamps, so a stale sheet can't masquerade as current data

There's also a new Download CSV (ZIP) action on dashboards, right next to Download Excel: one zip file with a CSV per report, plus a README.txt carrying the same context - link, filters, and per-file data freshness.

download-csv-zip.png

For API users: nothing changes by default - getReportData keeps its existing contract. Pass include_info_sheet: true to opt your XLSX exports into the Info sheet (API docs).

The Info sheet and README are enabled for all organizations; if you'd prefer exports without them, contact support.

A redesigned Preferences page — with one-click country presets

 

Improvement

  

Organization-wide settings deserve better than a wall of form fields. Preferences has moved to the ADMIN section of the gear menu (it was always admin territory at heart) and got a full redesign.

preferences-redesign.png

What you can do:

  • See your formatting at a glance: Data Formatting now shows a live preview of your date, time, number, and currency formats instead of a form. Click Customize only when you want to change something, with example values updating as you type.
  • Apply a country preset: pick from 16 countries and Cluvio sets the date/time formats, separators, currency symbol, and large-number abbreviations to local conventions in one click. Preview first, then save, or jump into Customize to fine-tune from there.

When starting a trial for a new organization, he welcome page now suggests a formatting preset matched to your location.

Detailed format options (including custom Moment.js format strings) are covered in the Preferences documentation.

A clearer datasource picker in the report editor

 

Improvement

  

datasource-selector.png

Choosing a datasource while building a report is now clearer. The picker groups your datasources into Available and Disabled sections with headers, shows the database type's logo on each row so you can recognize connections at a glance, and visibly dims disabled datasources so it's obvious which ones you can select — a small change that removes guesswork when you have many connections.

Introducing the Sparkline Metric Chart

 

Feature

  

sparkline-metric-chart-showcase.png

See a key number — and where it's heading — in one compact chart.

Until now you'd reach for the Number chart for a single KPI, or the Line chart for a full time series. The new Sparkline Metric chart sits neatly in between: a prominent headline value, a compact sparkline of the trend, and an optional delta showing how it has changed.

What you can do

  • Headline metric + trend — the latest value as a big number, with a sparkline of the whole series behind or beside it.
  • Delta at a glance — compare the current value to the first or previous point as an absolute change, a percentage, or both; flip on Down is good for metrics where lower is better.
  • Flexible layout — place the metric in any of 8 positions, or overlay it on a full-width sparkline background.
  • Make it yours — choose the sparkline color and fill, and add an icon from over 4,600 built-in icons.
  • Conditional formatting — style the value or delta, or recolor the sparkline when a threshold is crossed.
  • Interactive — drill down to another dashboard (or filter the current one), and click the metric to copy its value.

Great for KPI tiles like revenue, signups, active users, error rates, or latency — anywhere a number means more alongside its recent trend.

Getting started

Run a query that returns a value column (optionally with a timestamp), then choose Sparkline Metric as the chart type. It's suggested automatically for time series with 3 or more rows.

Learn more in the docs →

See your SQL alerts' run history at a glance

 

Feature

  

sql-alerts-activity.png

The SQL Alerts list now makes it easier to see how your alerts are behaving. A color-coded activity chart shows recent run history at a glance, with 24-hour and 30-day views, and a new Last Run column tells you when each alert last executed. You can sort the list by status, last run, or schedule, open a full alerts history, and hide the activity column if you prefer a simpler view — helping you spot a misbehaving alert faster.

⛁ Query CSV and Excel Files with SQL

 

Feature

  

You can now upload CSV and Excel (.xlsx) files directly to Cluvio and query them with SQL — no database required.

static-tables.png

Static Tables turn your files into fully queryable tables powered by Apache DataFusion. Upload a file, configure your columns, and start writing queries in minutes.

What you can do:

  • Upload CSV and Excel files and query them immediately with SQL.
  • Join data across files — all static tables share a single datasource.
  • Inspect your data during import — review column-level statistics, value distributions, configure types and a preview results before saving.
  • Update data easily by replacing the source file — Cluvio detects schema changes and guides you through them.

static-tables-upload-xlsx-table-config-column-detail.png

Static Tables are fully integrated with filters, SQL drop-down lists, code completion, and the Datasource Almanac, just like any other datasource.

static-tables-query-bb593dec3d30303edc6446dd3bf7955c.png

Learn more in the Static Tables documentation.

Redesigned Settings tables

 

Feature

  

settings-tables-redesign.png

We've refreshed the tables across the Settings area to make managing your account easier. Lists now support pagination and column sorting with stable column widths, and SQL Snippets and Filters show a Used-by count so you can see where each item is referenced before you change it.

You can also duplicate filters, snippets, and alerts in a click, jump straight to the right page after saving a new item, and move through global search results with the keyboard. Clearer icons and tooltips round out the update.

🙋‍♂️ Improved user and user group management

 

Feature

  

We’ve rolled out a major overhaul of user and user group management in Cluvio. The refreshed experience brings a cleaner interface, smoother interactions, and better visibility into key user details — including when users were last active, which dashboards they can access, and when they last opened them.

This update also improves performance for accounts with a very large number of users, making navigation faster and more responsive.

admin-users-list.png

BigQuery Labels

 

Feature

  

When executing queries on BigQuery datasources, Cluvio now attaches the following labels to each query job:

  • execution_id – A UUID that uniquely identifies a query execution in Cluvio. This is especially useful when troubleshooting a specific execution with the Cluvio Support Team.
  • execution_type – Either sql_query or export_query. The latter is only used for executions triggered by “unlimited CSV” exports.
  • user_id – The ID of the user that triggered the query - either an analyst who ran the query in the report editor or a user (viewer, analyst or admin) that triggered a manual refresh of the report/dashboard. For executions triggered by regular dashboard views (including viewer users and sharing links), this is not set.
  • report_id – The report that triggered the execution. Only set if the execution was triggered by a report.
  • filter_id – The filter that triggered the execution. Only set if the execution was triggered by a dropdown SQL filter.
  • sql_alert_id – The alert that triggered the execution. Only set if the execution was triggered by an alert.
  • sql_query_identity – A “fingerprint” of the SQL query. All queries that resolve to the same SQL after snippets are expanded share the same identity, even if they differ in Cluvio filter parameter values or are used on different reports.

You can use the global search in Cluvio to quickly find the corresponding entities (user, report, filter, SQL alert, or SQL query identity) by their ID.

More flexible value formatting for bar/line/pie charts

 

Improvement

  

Bar, line, and pie chart value formatting now lives in a new Formatting tab, with more flexible controls for abbreviation and rounding on the X and Y axes.

serial-charts-values-formatting.png

In addition to the more flexible formatting options, we’ve introduced a new time duration format with smart behavior: it chooses the most intuitive time unit for each value, so your time slices are always displayed in a clear, human-readable way.

format-duration.png