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 within Grafana, but none of them worked. I am not able to change the query for th…

You might want to check out the new SQL expression to group by ranges

I’m not using a SQL database. I am using Elastic Search with Lucene queries

[image] SQL expressions | Grafana documentation Manipulate and transform data in Grafana using SQL expressions. See this

OH, that’s very cool. Thank you. I’ll read through it. Quick question. Do you know if you can use that to get data after a transformation already? And then do more transformations after the SQL expressions.

My method is never ever use transformation unless the datasource does not provide a means to get what you need. Sql expression is pretty much the answer to transformations Grafana [image] [image]

Thank you very much. I am running into a small issue when I try to do it. My field name for age is ‘tag.age.keyword’ and when I try to put that in SQL I am getting an error, I am going to read up on SQL and see if/how I can fix this, but if you know the answer and can help me that’d be great. EDIT:…

What does your sql query look like?

SELECT COUNT(*) AS how_many_peeps, CASE WHEN age = '4_12' THEN '4_12' WHEN age = '13_18' THEN '13_18' WHEN age = '19_30' THEN '19_30' WHEN age = '31_50' THEN '31_50' WHEN age = '50+' THEN '50+' WHEN age BETWEEN 0 AND 3 THEN '0_3' WHEN age BETWEEN 4 AND …

Remove Union all Add LIMIT 100 at the end of the query for test purposes

Grouping data in a table by conditions

Grafana Dashboards

Topic		Replies	Views
Evaluate two queries to one line InfluxDB transformations	2	134	January 7, 2025
Time range dependent SQL queries for graphs Time Series Panel	2	9558	November 15, 2020
Is Possible to get value from time range grafana and put it inside query in table panel? Grafana	0	577	January 2, 2019
Expression query produce 1 timeserie by grouped by row Elasticsearch elasticsearch , expressions	0	465	July 26, 2023
Grafana with dynamodb, create query that groups by month and counts rows PostgreSQL	3	140	November 20, 2024

Grouping data in a table by conditions

Related topics