# \#transformations **URL:** https://community.grafana.com/tag/transformations/54.md [Latest](https://community.grafana.com/latest.md) · [Categories](https://community.grafana.com/categories.md) · [Tags](https://community.grafana.com/tags.md) --- ## [Group data by row value](https://community.grafana.com/t/group-data-by-row-value/164665)
**Author:** [@arnaubria](https://community.grafana.com/u/arnaubria)\ **Replies:** 3\ **Last updated:** [October 10, 2026, 3:10pm UTC](https://community.grafana.com/t/group-data-by-row-value/164665 "2026-10-10T15:10:12Z")
Dear all, I’m trying to get a gauge (i think this is what I want) panel that should show 2 values: members of an AD group - members in that AD group that have logged to a system. I get all the information from 2 querie… --- ## [How can I use a transformation in an expression?](https://community.grafana.com/t/how-can-i-use-a-transformation-in-an-expression/164039)
**Author:** [@ROView](https://community.grafana.com/u/ROView)\ **Replies:** 1\ **Last updated:** [August 4, 2026, 2:53am UTC](https://community.grafana.com/t/how-can-i-use-a-transformation-in-an-expression/164039 "2026-08-04T02:53:13Z")
Hello, I am have been manipulating data sets using transformations but have not had a way to use that transformation in an expression. Is there a way to add this transformation into a way that I can do math on it, or m… --- ## [Unexpected results when combining multiple "Add field from calculation" transformations](https://community.grafana.com/t/unexpected-results-when-combining-multiple-add-field-from-calculation-transformations/163955)
**Author:** [@Snafu](https://community.grafana.com/u/Snafu)\ **Replies:** 2\ **Last updated:** [July 30, 2026, 2:49pm UTC](https://community.grafana.com/t/unexpected-results-when-combining-multiple-add-field-from-calculation-transformations/163955 "2026-07-30T14:49:34Z")
Using Grafana v13.1.0, I am trying to find old images and image missmatches running in multiple kubernetes clusters. Normally I would expect that all pods/containers across all cluster/namespace combinations run the sam… --- ## [How to implement a writable modal popup in a Grafana dashboard without leaving the current dashboard?](https://community.grafana.com/t/how-to-implement-a-writable-modal-popup-in-a-grafana-dashboard-without-leaving-the-current-dashboard/163821)
**Author:** [@rohitrs9255](https://community.grafana.com/u/rohitrs9255)\ **Replies:** 5\ **Last updated:** [July 29, 2026, 5:02am UTC](https://community.grafana.com/t/how-to-implement-a-writable-modal-popup-in-a-grafana-dashboard-without-leaving-the-current-dashboard/163821 "2026-07-29T05:02:08Z")
Hi everyone, I am developing a Grafana dashboard where users can click an icon to open a modal popup without leaving or closing the current dashboard. The popup should contain an editable form with fields such as: I… --- ## [Need an advice on how to transform a date](https://community.grafana.com/t/need-an-advice-on-how-to-transform-a-date/162305)
**Author:** [@ansans](https://community.grafana.com/u/ansans)\ **Replies:** 9\ **Last updated:** [April 1, 2026, 4:20pm UTC](https://community.grafana.com/t/need-an-advice-on-how-to-transform-a-date/162305 "2026-04-01T16:20:17Z")
I use Grafana v11.0.0 I want to display metrics in a table where: rows = location columns = probe values = aggregated metric (AVG of selected metric) Example of desired output: location | probe\_1 | prob… --- ## [How to add units to a timeseries panel with dynamic metrics sourced from DynamoDB](https://community.grafana.com/t/how-to-add-units-to-a-timeseries-panel-with-dynamic-metrics-sourced-from-dynamodb/161967)
**Author:** [@mike1c34](https://community.grafana.com/u/mike1c34)\ **Replies:** 4\ **Last updated:** [March 30, 2026, 5:34am UTC](https://community.grafana.com/t/how-to-add-units-to-a-timeseries-panel-with-dynamic-metrics-sourced-from-dynamodb/161967 "2026-03-30T05:34:31Z")
Hi all, I am using Cloud Hosted Grafana (v13.0) and my data source is DynamoDB. I have a simple dashboard with a multi-value variable (30 options) where the user can select some metrics to plot on a timeseries chart. T… --- ## [There's a way to replace values in grafana?](https://community.grafana.com/t/theres-a-way-to-replace-values-in-grafana/161824)
**Author:** [@san2rio](https://community.grafana.com/u/san2rio)\ **Replies:** 3\ **Last updated:** [March 27, 2026, 9:04am UTC](https://community.grafana.com/t/theres-a-way-to-replace-values-in-grafana/161824 "2026-03-27T09:04:24Z")
I have a check mk data source, i have the idea to transform every 0 values into a boolean automatically but i can’t find any way to do this in the transformations i only found solutions for the most used data sources but… --- ## [About transformation tab issue](https://community.grafana.com/t/about-transformation-tab-issue/162072)
**Author:** [@akash01601](https://community.grafana.com/u/akash01601)\ **Replies:** 0\ **Last updated:** [March 12, 2026, 5:01am UTC](https://community.grafana.com/t/about-transformation-tab-issue/162072 "2026-03-12T05:01:07Z")
We are currently using Grafana v9.x and Grafana v12.x. In some of our panels, we use the Transformation → Reduce row option to calculate values. In Grafana v9.x, the panel displays the correct values as expected. Howev… --- ## [Transform Outer Join when one query has no results](https://community.grafana.com/t/transform-outer-join-when-one-query-has-no-results/161819)
**Author:** [@garethsrt](https://community.grafana.com/u/garethsrt)\ **Replies:** 5\ **Last updated:** [February 25, 2026, 1:18pm UTC](https://community.grafana.com/t/transform-outer-join-when-one-query-has-no-results/161819 "2026-02-25T13:18:33Z")
Hi, I have a strange / unexpected transformation outer join result if one of the query results is empty. I wonder if anyone else has come across this and has a good solution? To illustrate (with some pseudo-results): 1… --- ## [How to merge rows from 3 Loki queries by 1-second time buckets in Geomap?](https://community.grafana.com/t/how-to-merge-rows-from-3-loki-queries-by-1-second-time-buckets-in-geomap/161652)
**Author:** [@toon2](https://community.grafana.com/u/toon2)\ **Replies:** 3\ **Last updated:** [February 20, 2026, 4:26am UTC](https://community.grafana.com/t/how-to-merge-rows-from-3-loki-queries-by-1-second-time-buckets-in-geomap/161652 "2026-02-20T04:26:12Z")
What Grafana version and what operating system are you using? Grafana Cloud v12.4.0 What are you trying to achieve? I have a Geomap panel with 3 Loki queries that each return different data with their own timestamps… --- ## [How to send noisy topics to the end of the list?](https://community.grafana.com/t/how-to-send-noisy-topics-to-the-end-of-the-list/161724)
**Author:** [@gshriram2019](https://community.grafana.com/u/gshriram2019)\ **Replies:** 3\ **Last updated:** [February 18, 2026, 5:51am UTC](https://community.grafana.com/t/how-to-send-noisy-topics-to-the-end-of-the-list/161724 "2026-02-18T05:51:35Z")
What Grafana version and what operating system are you using? Grafana v11.2.2+security-01 What are you trying to achieve? Trying to stop noisy topics that are not monitored from cluttering my topics list at th… --- ## [Graphing rate per second from randomly timed deltas](https://community.grafana.com/t/graphing-rate-per-second-from-randomly-timed-deltas/161526)
**Author:** [@mnewton3](https://community.grafana.com/u/mnewton3)\ **Replies:** 5\ **Last updated:** [February 6, 2026, 4:37pm UTC](https://community.grafana.com/t/graphing-rate-per-second-from-randomly-timed-deltas/161526 "2026-02-06T16:37:53Z")
Hey all, I’m having some trouble charting some data, and it looks like InfluxQL may not be able to do what I need. That is, do some math using the time difference between two rows. So I’m hoping that Grafana can do the w… --- ## [Calculating energy based on Power measures](https://community.grafana.com/t/calculating-energy-based-on-power-measures/161048)
**Author:** [@wojtekjurewicz](https://community.grafana.com/u/wojtekjurewicz)\ **Replies:** 0\ **Last updated:** [January 15, 2026, 3:46pm UTC](https://community.grafana.com/t/calculating-energy-based-on-power-measures/161048 "2026-01-15T15:46:33Z")
Newbie question, as I just start with Grafana. I have a Power (kW) measures in InfluxDB. How could I create a bar chart with Energy measures (kWh)? I assume I need to somehow transform it and combine with time, but how t… --- ## [Grouping data in a table by conditions](https://community.grafana.com/t/grouping-data-in-a-table-by-conditions/159740)
**Author:** [@micahgould1](https://community.grafana.com/u/micahgould1)\ **Replies:** 14\ **Last updated:** [December 3, 2025, 5:39pm UTC](https://community.grafana.com/t/grouping-data-in-a-table-by-conditions/159740 "2025-12-03T17:39:38Z")
I have a table that has Ages of people and the Count of people with that age. I want to simplify the table by creating age ranges (e.g. 0-4, 4-12, 13-18, etc.). I have played around with a few different transformations w… --- ## [Percentage calculation on 2 queries in Grafana Tempo Data source is not working](https://community.grafana.com/t/percentage-calculation-on-2-queries-in-grafana-tempo-data-source-is-not-working/159559)
**Author:** [@arvinnogal](https://community.grafana.com/u/arvinnogal)\ **Replies:** 0\ **Last updated:** [November 20, 2025, 11:20am UTC](https://community.grafana.com/t/percentage-calculation-on-2-queries-in-grafana-tempo-data-source-is-not-working/159559 "2025-11-20T11:20:06Z")
What Grafana version and what operating system are you using? - Grafana version 12.4.0 (build 19378664917). Cloud Free edition running in a production environment What are you trying to achieve? - Show percentage of… --- ## [Merge up status and instance\_name panel](https://community.grafana.com/t/merge-up-status-and-instance-name-panel/159092)
**Author:** [@curtisl](https://community.grafana.com/u/curtisl)\ **Replies:** 9\ **Last updated:** [November 16, 2025, 5:22pm UTC](https://community.grafana.com/t/merge-up-status-and-instance-name-panel/159092 "2025-11-16T17:22:26Z")
What Grafana version and what operating system are you using? Grafana v12.2.1 (563109b696) What are you trying to achieve? I am trying to merge the results of 2 prometheus metrics, up and server\_name into one pane… --- ## [Transformations time series to table show json frame](https://community.grafana.com/t/transformations-time-series-to-table-show-json-frame/159150)
**Author:** [@weizibin](https://community.grafana.com/u/weizibin)\ **Replies:** 2\ **Last updated:** [November 10, 2025, 10:19am UTC](https://community.grafana.com/t/transformations-time-series-to-table-show-json-frame/159150 "2025-11-10T10:19:58Z")
What Grafana version and what operating system are you using? Grafana v12.0.0 (4c0e7045f9) What are you trying to achieve? Display HTTP client availability metrics in a table view. How are you trying to ach… --- ## [How to aggregate multiple CloudWatch metrics into a single total for success rate calculation?](https://community.grafana.com/t/how-to-aggregate-multiple-cloudwatch-metrics-into-a-single-total-for-success-rate-calculation/159140)
**Author:** [@scl67](https://community.grafana.com/u/scl67)\ **Replies:** 14\ **Last updated:** [November 7, 2025, 2:39pm UTC](https://community.grafana.com/t/how-to-aggregate-multiple-cloudwatch-metrics-into-a-single-total-for-success-rate-calculation/159140 "2025-11-07T14:39:32Z")
Hello, I am looking for advice on how to agregate multiple numeric values into a single value from a list of dimension values. What Grafana version and what operating system are you using? Amazon Managed Grafana 10.4… --- ## [Create an alert from a Redis datasource list](https://community.grafana.com/t/create-an-alert-from-a-redis-datasource-list/155267)
**Author:** [@awenine](https://community.grafana.com/u/awenine)\ **Replies:** 1\ **Last updated:** [September 24, 2025, 3:49pm UTC](https://community.grafana.com/t/create-an-alert-from-a-redis-datasource-list/155267 "2025-09-24T15:49:14Z")
(using Grafana v12.0.2 running on Ubuntu) Hi all, I am trying to create an alert that triggers when the latest timestamp in a Redis datasource (stored as a LIST) is older than a certain amount (indicating that the serv… --- ## ["Transpose" transformation overrides name changes made with a preceding "Organize field by names"](https://community.grafana.com/t/transpose-transformation-overrides-name-changes-made-with-a-preceding-organize-field-by-names/143867)
**Author:** [@jakubleszczynski](https://community.grafana.com/u/jakubleszczynski)\ **Replies:** 2\ **Last updated:** [September 16, 2025, 8:30am UTC](https://community.grafana.com/t/transpose-transformation-overrides-name-changes-made-with-a-preceding-organize-field-by-names/143867 "2025-09-16T08:30:39Z")
What Grafana version and what operating system are you using? 11.5.1 with a Prometheus datasource What are you trying to achieve? I’m trying to design a table that will show particulat services status for some serve… --- ## [Transform a single row value into replicated column across multiple rows using Grafana transforms](https://community.grafana.com/t/transform-a-single-row-value-into-replicated-column-across-multiple-rows-using-grafana-transforms/156525)
**Author:** [@andreas69](https://community.grafana.com/u/andreas69)\ **Replies:** 2\ **Last updated:** [August 21, 2025, 8:16am UTC](https://community.grafana.com/t/transform-a-single-row-value-into-replicated-column-across-multiple-rows-using-grafana-transforms/156525 "2025-08-21T08:16:22Z")
Context Using Grafana 11 with a data table containing: One “Runtime” row with total machine operating duration Multiple rows for each failure cause with their occurrence count Current Data Structure Field … --- ## [Passing $\_\_from and $\_\_to as custom variables incorrectly](https://community.grafana.com/t/passing-from-and-to-as-custom-variables-incorrectly/156077)
**Author:** [@toon2](https://community.grafana.com/u/toon2)\ **Replies:** 5\ **Last updated:** [August 21, 2025, 7:04am UTC](https://community.grafana.com/t/passing-from-and-to-as-custom-variables-incorrectly/156077 "2025-08-21T07:04:21Z")
What Grafana version and what operating system are you using? 12.2.0-16677249643 What are you trying to achieve? Apply a filter on the time range with ‘filter data by values’ transformation. How are you tryin… --- ## [Grafana Stat Panel Showing Incorrect Float Values Instead of Integers](https://community.grafana.com/t/grafana-stat-panel-showing-incorrect-float-values-instead-of-integers/155889)
**Author:** [@markfree](https://community.grafana.com/u/markfree)\ **Replies:** 2\ **Last updated:** [August 8, 2025, 4:19pm UTC](https://community.grafana.com/t/grafana-stat-panel-showing-incorrect-float-values-instead-of-integers/155889 "2025-08-08T16:19:04Z")
Grafana 11.4 Data source Zabbix 7.2 I have a stat panel that collects multiple metrics from its data-source. It’s query option uses a 24h relative time. I use this main panel as a source for other panels, each … --- ## [Oversampling problem with cumulative sum](https://community.grafana.com/t/oversampling-problem-with-cumulative-sum/154243)
**Author:** [@jaroslavprochazka](https://community.grafana.com/u/jaroslavprochazka)\ **Replies:** 5\ **Last updated:** [August 5, 2025, 9:16am UTC](https://community.grafana.com/t/oversampling-problem-with-cumulative-sum/154243 "2025-08-05T09:16:54Z")
Hello, I would like to calculate power consumption over time using cumulative sum function. The data is coming with 1 second period. The problem is when I select wider timer range, the data get oversampled, the sum is c… --- ## [If then logic work around with filters](https://community.grafana.com/t/if-then-logic-work-around-with-filters/155369)
**Author:** [@kkin](https://community.grafana.com/u/kkin)\ **Replies:** 2\ **Last updated:** [July 31, 2025, 12:08am UTC](https://community.grafana.com/t/if-then-logic-work-around-with-filters/155369 "2025-07-31T00:08:45Z")
I am pulling tags from Enterprise PI Historian and trying to perform conditional calculations to calculate equipment throughput in containers per minute based on belt speed. Each recipe has a different speed and a differ… --- ## [I cannot find JSONata transformation in my Grafana opensource panel](https://community.grafana.com/t/i-cannot-find-jsonata-transformation-in-my-grafana-opensource-panel/154989)
**Author:** [@krishnasv1018](https://community.grafana.com/u/krishnasv1018)\ **Replies:** 1\ **Last updated:** [July 23, 2025, 12:59pm UTC](https://community.grafana.com/t/i-cannot-find-jsonata-transformation-in-my-grafana-opensource-panel/154989 "2025-07-23T12:59:26Z")
I have configured MQTT as a data source in Grafana and given the respected topic it was showing no data, and I’m receiving JSON data in an array format. To parse this data, I want to use the JSONata transformation, but … --- ## [Format String Transformation not visible](https://community.grafana.com/t/format-string-transformation-not-visible/154907)
**Author:** [@iamrj306](https://community.grafana.com/u/iamrj306)\ **Replies:** 1\ **Last updated:** [July 21, 2025, 8:07pm UTC](https://community.grafana.com/t/format-string-transformation-not-visible/154907 "2025-07-21T20:07:23Z")
My organization is using Grafana Enterprise version 11.1.3 Under the Transform tab I am not able to see the “Format String” transformation. Is this expected? --- ## [Stats with transpose of one field to summarized columns depending on field content](https://community.grafana.com/t/stats-with-transpose-of-one-field-to-summarized-columns-depending-on-field-content/153949)
**Author:** [@bdein](https://community.grafana.com/u/bdein)\ **Replies:** 4\ **Last updated:** [July 18, 2025, 4:12pm UTC](https://community.grafana.com/t/stats-with-transpose-of-one-field-to-summarized-columns-depending-on-field-content/153949 "2025-07-18T16:12:41Z")
FYI: I come from the Splunk world with 10+ years of experience with all kinds of “interesting” query experience, so I hope and try to achieve some of the same tricks here in Grafana, and one comes here :wink: What Gra… --- ## [How can extract the version in this path](https://community.grafana.com/t/how-can-extract-the-version-in-this-path/154471)
**Author:** [@aryangoswami023](https://community.grafana.com/u/aryangoswami023)\ **Replies:** 1\ **Last updated:** [July 14, 2025, 9:23am UTC](https://community.grafana.com/t/how-can-extract-the-version-in-this-path/154471 "2025-07-14T09:23:04Z")
j @yosiasz @grant2 please suggest i want to extrace the version of grafana. --- ## [Detecting Duplicates](https://community.grafana.com/t/detecting-duplicates/153854)
**Author:** [@brahmeshlodhi](https://community.grafana.com/u/brahmeshlodhi)\ **Replies:** 1\ **Last updated:** [July 3, 2025, 5:01pm UTC](https://community.grafana.com/t/detecting-duplicates/153854 "2025-07-03T17:01:48Z")
Is there a optimal way to detect duplicate logs using transformation for a huge data like 60k - 80k log lines, i have tried but working for only small amount of data. [Next page](https://community.grafana.com/tag/transformations/54.md?match_all_tags=true&page=1&tags%5B%5D=transformations)