- What Grafana version and what operating system are you using?
11.4.0-79146 - What are you trying to achieve?
I’ve a time series data that has time and percentage as fields. This is a sample query - avg by ()(kubernetes_io:container_cpu_request_utilization{…}) * 100. I’ve such 14 queries that return the data as time and percentage. Each query returns a single result as I’ve set it to return ‘Instance’. I am transposing them so time field becomes column name. I need to sort on this column. Since the column name is variable when I specify this in transformation initially it works at that instance, but as soon as I run it after some time the sorting goes away. - How are you trying to achieve it?
I’m using transpose to covert the rows to column for display using transformations. After doing this I’m trying to sort on columns, but since the value of column changes frequently the sorting goes away. I see the results as un-sorted. - What happened?
The results are unsorted. - What did you expect to happen?
I want to sort the results. - Can you copy/paste the configuration(s) that you are having problems with?
“transformations”: [
{
“id”: “merge”,
“options”: {}
},
{
“id”: “transpose”,
“options”: {}
},
{
“id”: “formatString”,
“options”: {
“outputFormat”: “Substring”,
“stringField”: “Field”,
“substringStart”: 7
}
},
{
“id”: “sortBy”,
“options”: {
“fields”: {},
“sort”: [
{
“desc”: true,
“field”: “1732561753928”
}
]
}
}
] - Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
No errors - Did you follow any online instructions? If so, what is the URL?
None
