Menu
Grafana Cloud
← Back to What's new
Generally AvailableDashboards and visualizations
Release date: 2024-08-09

Transformation updates

We’ve made a number of exciting updates to transformations!

You can now use variables in some transformations

Template variables are now supported for the Limit, Sort by, Filter data by values, Grouping to matrix (a community contribution ⭐️), Heatmap, and Histogram transformations. This enables dynamic transformation configurations based on panel data and dashboard variables.

New transpose transformation

We’re excited to announce the new Transpose transformation, which allows you to pivot the data frame, converting rows into columns and columns into rows. This feature is particularly useful for data sources that don’t support pivot queries, enabling more flexible and insightful data visualizations.

For more information, refer to the documentation.

Transpose transformation in action

This feature is a community contribution ❤️

Group to nested tables is now generally available

We’re excited to announce that the Group to nested tables transformation is now generally available! Easily group your table data by specified fields and perform calculations on each group. With this transformation, you can enhance the depth and utility of your table visualizations.

See the documentation for more information.

Group to nested tables transformation

Format string is now generally available

The Format string transformation is now generally available! Use this transformation to customize the output of a string field. From formatting your string data to upper, lower, title case, and more, this transformation provides a convenient way to standardize and tailor the presentation of string data for better visualization and analysis. See the documentation for more information.

New cumulative and window calculations available in Add field from calculation

The Add field from calculation transformation now supports both cumulative and window calculations. The cumulative function calculates on the current row and all preceding rows. You can calculate the total or the mean of your data up to and including the current row. With the window function you can calculate the mean, standard deviation, or variance on a specified set (window) of your data. The window can either be trailing or centered. With a trailing window the current row will be the last row in the window. With a centered window the window will be centered on the current row.

See the documentation for more information.