# \#query-help

**URL:** https://community.grafana.com/tag/query-help/30.md

[Latest](https://community.grafana.com/latest.md) · [Categories](https://community.grafana.com/categories.md) · [Tags](https://community.grafana.com/tags.md)

---

## [Query Builder field list only shows "\*" instead of table columns (self-hosted Grafana)](https://community.grafana.com/t/query-builder-field-list-only-shows-instead-of-table-columns-self-hosted-grafana/164350)

<div class="topic-metadata">

**Author:** [@garysirman](https://community.grafana.com/u/garysirman)\
**Replies:** 4\
**Last updated:** [September 9, 2026, 2:13pm UTC](https://community.grafana.com/t/query-builder-field-list-only-shows-instead-of-table-columns-self-hosted-grafana/164350 "2026-09-09T14:13:18Z")

</div>

What Grafana version and what operating system are you using? Grafana version: v12.3.1 (0d1a5b4420) — running as Enterprise (Free & unlicensed) Self-hosted. What are you trying to achieve? We’re trying to build a das…

---

## [Loki + S3: Why It’s Slow and How to Fix It](https://community.grafana.com/t/loki-s3-why-it-s-slow-and-how-to-fix-it/164179)

<div class="topic-metadata">

**Author:** [@uttamreetesh](https://community.grafana.com/u/uttamreetesh)\
**Replies:** 2\
**Last updated:** [September 8, 2026, 12:41pm UTC](https://community.grafana.com/t/loki-s3-why-it-s-slow-and-how-to-fix-it/164179 "2026-09-08T12:41:34Z")

</div>

https://medium.com/me/stats/post/220acab20d13 What the Numbers Looked Like in the End We made all these changes in a single session. Here’s the before and after: | What we measured | Before | After …

---

## [Turning a Totalizer into a Daily Resettable Totalizer (Saw Blade Look)](https://community.grafana.com/t/turning-a-totalizer-into-a-daily-resettable-totalizer-saw-blade-look/163981)

<div class="topic-metadata">

**Author:** [@ROView](https://community.grafana.com/u/ROView)\
**Replies:** 8\
**Last updated:** [August 5, 2026, 5:24am UTC](https://community.grafana.com/t/turning-a-totalizer-into-a-daily-resettable-totalizer-saw-blade-look/163981 "2026-08-05T05:24:02Z")

</div>

Hey reader, long time lurker first time poster. Hoping someone with wisdom beyond my own can guide a young padawan. The version of Grafana I am using is: Grafana v11.3.1 (9225f4a1cb) I am trying to turn a cumulative to…

---

## [Storage panel populating no Data on my Grafana Zabbix Dashboard](https://community.grafana.com/t/storage-panel-populating-no-data-on-my-grafana-zabbix-dashboard/163740)

<div class="topic-metadata">

**Author:** [@akinyemi001](https://community.grafana.com/u/akinyemi001)\
**Replies:** 2\
**Last updated:** [July 15, 2026, 6:19am UTC](https://community.grafana.com/t/storage-panel-populating-no-data-on-my-grafana-zabbix-dashboard/163740 "2026-07-15T06:19:33Z")

</div>

Hello Community, I have a dashboard with a zabbix data source with ID 5363 but it is showing “No Data” on the Filesystem(space utilization%) panel. Please can anyone help?

---

## [Problem changing intervals on stacked bar chart](https://community.grafana.com/t/problem-changing-intervals-on-stacked-bar-chart/163633)

<div class="topic-metadata">

**Author:** [@waggers](https://community.grafana.com/u/waggers)\
**Replies:** 7\
**Last updated:** [July 11, 2026, 7:41am UTC](https://community.grafana.com/t/problem-changing-intervals-on-stacked-bar-chart/163633 "2026-07-11T07:41:04Z")

</div>

I am producing a time-series chart showing the power input to my inverter. I am running version 13.1 of Grafrana and pulling the data from a Postgres database fed by Homey. The native data is at 15 minute intervals and …

---

## [OCI Metrics Datasource Builder returns only tenancy root compartment; child compartments are not listed (Grafana 13.1.0, plugin 6.5.5, ARM64)](https://community.grafana.com/t/oci-metrics-datasource-builder-returns-only-tenancy-root-compartment-child-compartments-are-not-listed-grafana-13-1-0-plugin-6-5-5-arm64/163541)

<div class="topic-metadata">

**Author:** [@ronaldodorigo](https://community.grafana.com/u/ronaldodorigo)\
**Replies:** 5\
**Last updated:** [July 10, 2026, 9:44am UTC](https://community.grafana.com/t/oci-metrics-datasource-builder-returns-only-tenancy-root-compartment-child-compartments-are-not-listed-grafana-13-1-0-plugin-6-5-5-arm64/163541 "2026-07-10T09:44:02Z")

</div>

We are experiencing an issue with the OCI Metrics Datasource where the Builder does not list compartments correctly. In the COMPARTMENT field, only the tenancy root compartment is returned. First-level compartments and …

---

## [AQL queries take 30+ min even on a 5-min time range, but CPU/RAM on both Grafana and QRadar are low — why?](https://community.grafana.com/t/aql-queries-take-30-min-even-on-a-5-min-time-range-but-cpu-ram-on-both-grafana-and-qradar-are-low-why/163419)

<div class="topic-metadata">

**Author:** [@irvanfebrianto1998](https://community.grafana.com/u/irvanfebrianto1998)\
**Replies:** 6\
**Last updated:** [July 1, 2026, 10:37am UTC](https://community.grafana.com/t/aql-queries-take-30-min-even-on-a-5-min-time-range-but-cpu-ram-on-both-grafana-and-qradar-are-low-why/163419 "2026-07-01T10:37:54Z")

</div>

Hi everyone, I have Grafana integrated with IBM QRadar SIEM (v7.5.0 UP12) using the ibm-aql-datasource plugin. The setup has 9 dashboards with 60+ panels total, each running AQL queries against QRadar. The strange issu…

---

## [Loki - config for faster query performance](https://community.grafana.com/t/loki-config-for-faster-query-performance/163294)

<div class="topic-metadata">

**Author:** [@vallikanusekarart](https://community.grafana.com/u/vallikanusekarart)\
**Replies:** 6\
**Last updated:** [June 19, 2026, 7:36am UTC](https://community.grafana.com/t/loki-config-for-faster-query-performance/163294 "2026-06-19T07:36:29Z")

</div>

Hi, I’m using loki 17.5.1 helm chart I have 3 ingester replicas with 10gb and 2 cpu limit each. 6 querier replicas with 6gb and 2 cpu limit each. Max\_concurrent is 16, Max\_query\_parallelism is 48, split query interval …

---

## [BigQuery : DoiT International to Native Grafana Data Source Migration](https://community.grafana.com/t/bigquery-doit-international-to-native-grafana-data-source-migration/163303)

<div class="topic-metadata">

**Author:** [@vadiksdba](https://community.grafana.com/u/vadiksdba)\
**Replies:** 3\
**Last updated:** [June 16, 2026, 4:57pm UTC](https://community.grafana.com/t/bigquery-doit-international-to-native-grafana-data-source-migration/163303 "2026-06-16T16:57:01Z")

</div>

Hi Grafana Team, We are heavily using BigQuery with Grafana and currently rely on the DoiT International BigQuery plugin across our environment. As part of our Grafana upgrade initiative, we are planning to migrate to …

---

## [Operato Windrose - Problems to plot](https://community.grafana.com/t/operato-windrose-problems-to-plot/163123)

<div class="topic-metadata">

**Author:** [@agustinignaciodona](https://community.grafana.com/u/agustinignaciodona)\
**Replies:** 2\
**Last updated:** [June 2, 2026, 2:58am UTC](https://community.grafana.com/t/operato-windrose-problems-to-plot/163123 "2026-06-02T02:58:51Z")

</div>

Hello dear community, I’ve recently installed the Operato Windrose plugin (Operato Windrose plugin for Grafana | Grafana Labs). As per its instruction, data must follow the names wind\_speed and wind\_direction, such as: …

---

## [Variable scopedVars keys become undefined after upgrading to Grafana v12 – breaking custom datasource plugin](https://community.grafana.com/t/variable-scopedvars-keys-become-undefined-after-upgrading-to-grafana-v12-breaking-custom-datasource-plugin/163037)

<div class="topic-metadata">

**Author:** [@XMASyuan](https://community.grafana.com/u/XMASyuan)\
**Replies:** 2\
**Last updated:** [May 28, 2026, 4:13am UTC](https://community.grafana.com/t/variable-scopedvars-keys-become-undefined-after-upgrading-to-grafana-v12-breaking-custom-datasource-plugin/163037 "2026-05-28T04:13:24Z")

</div>

Hi Grafana Community, We recently upgraded our Grafana instance from v10.4.19 to v12.4.3 and encountered a critical issue with variable passing in dashboards that use a custom datasource plugin (which is now deprecated …

---

## [Dynamic measurement naming](https://community.grafana.com/t/dynamic-measurement-naming/162878)

<div class="topic-metadata">

**Author:** [@kwi1](https://community.grafana.com/u/kwi1)\
**Replies:** 3\
**Last updated:** [May 13, 2026, 11:38am UTC](https://community.grafana.com/t/dynamic-measurement-naming/162878 "2026-05-13T11:38:22Z")

</div>

Hi everyone, I’m struggling with a visualization issue where my metadata (zone name) changes over time, while the unique identifier (zone ID) remains the same. Raw data example: Measurement,zone=1 Act\_Temp=20.530,name=…

---

## [Does Grafana support all the CVE fixes in Security Support](https://community.grafana.com/t/does-grafana-support-all-the-cve-fixes-in-security-support/162848)

<div class="topic-metadata">

**Author:** [@sonalasharma](https://community.grafana.com/u/sonalasharma)\
**Replies:** 2\
**Last updated:** [May 11, 2026, 10:02am UTC](https://community.grafana.com/t/does-grafana-support-all-the-cve-fixes-in-security-support/162848 "2026-05-11T10:02:25Z")

</div>

Does Grafana support all the CVE fixes in Security Support. 13.x is the latest release but security support is only till Jan’27 while 12.4.3 is the old release with no active support but only secuirty support till May’27…

---

## [Inconsistency in OSS Grafana query options](https://community.grafana.com/t/inconsistency-in-oss-grafana-query-options/162658)

<div class="topic-metadata">

**Author:** [@mabnz](https://community.grafana.com/u/mabnz)\
**Replies:** 2\
**Last updated:** [May 10, 2026, 6:37pm UTC](https://community.grafana.com/t/inconsistency-in-oss-grafana-query-options/162658 "2026-05-10T18:37:32Z")

</div>

If I change the time picker to now-1M/M, I see it shows data from the previous month; the first day of the previous month to the last day of the previous month. However, if I use “now-1M/M” in a Query option, it will sh…

---

## [Can I use multiple SQL statements in a single MySQL query?](https://community.grafana.com/t/can-i-use-multiple-sql-statements-in-a-single-mysql-query/162821)

<div class="topic-metadata">

**Author:** [@huangsijun17](https://community.grafana.com/u/huangsijun17)\
**Replies:** 3\
**Last updated:** [May 9, 2026, 6:00am UTC](https://community.grafana.com/t/can-i-use-multiple-sql-statements-in-a-single-mysql-query/162821 "2026-05-09T06:00:36Z")

</div>

What Grafana version and what operating system are you using? Grafana v11.4.0 (b58701869e) What are you trying to achieve? Before using AES\_DECRYPT() , set SET SESSION block\_encryption\_mode = 'aes-256-ecb'; …

---

## [Need help with GROT Academy Lab Section PromQL. Currently Stuck](https://community.grafana.com/t/need-help-with-grot-academy-lab-section-promql-currently-stuck/158452)

<div class="topic-metadata">

**Author:** [@jarpadul](https://community.grafana.com/u/jarpadul)\
**Replies:** 7\
**Last updated:** [May 8, 2026, 1:40pm UTC](https://community.grafana.com/t/need-help-with-grot-academy-lab-section-promql-currently-stuck/158452 "2026-05-08T13:40:37Z")

</div>

What Grafana version and what operating system are you using? Grafana Cloud, Windows 11 (Using Brave Browser) What are you trying to achieve? I was following the tutorial at GROT Academy: https://learn.grafana.c…

---

## [How to properly add Grafana monitoring to a custom video editing app](https://community.grafana.com/t/how-to-properly-add-grafana-monitoring-to-a-custom-video-editing-app/162589)

<div class="topic-metadata">

**Author:** [@alishawinson](https://community.grafana.com/u/alishawinson)\
**Replies:** 2\
**Last updated:** [April 21, 2026, 9:47am UTC](https://community.grafana.com/t/how-to-properly-add-grafana-monitoring-to-a-custom-video-editing-app/162589 "2026-04-21T09:47:05Z")

</div>

Hi everyone, I’m building a custom video editor application similar to the link and I want to add performance monitoring using Grafana. From what I understand, Grafana doesn’t directly monitor an app. It needs metrics/l…

---

## [Zabbix – Show only alerts triggered more than 40 minutes ago](https://community.grafana.com/t/zabbix-show-only-alerts-triggered-more-than-40-minutes-ago/162357)

<div class="topic-metadata">

**Author:** [@sgabrielalmeida](https://community.grafana.com/u/sgabrielalmeida)\
**Replies:** 8\
**Last updated:** [April 7, 2026, 2:23pm UTC](https://community.grafana.com/t/zabbix-show-only-alerts-triggered-more-than-40-minutes-ago/162357 "2026-04-07T14:23:22Z")

</div>

Hey guys, I’m trying to create a panel in Grafana that only shows Zabbix alerts that were triggered more than 40 minutes ago. I’ve been trying to figure this out for over a week and I’ve reached a point where I don’t kno…

---

## [Data in fontend and querier query stat logs differs](https://community.grafana.com/t/data-in-fontend-and-querier-query-stat-logs-differs/162363)

<div class="topic-metadata">

**Author:** [@slime28](https://community.grafana.com/u/slime28)\
**Replies:** 0\
**Last updated:** [April 2, 2026, 4:42pm UTC](https://community.grafana.com/t/data-in-fontend-and-querier-query-stat-logs-differs/162363 "2026-04-02T16:42:40Z")

</div>

Hello, Why does the data in query stat logs differ in frontend and querier logs? When I sum values of all cache\_chunk\_bytes\_stored fields in frontend and querier logs, for the same query, I see the difference. The same…

---

## [Critical Access Issue: "Error loading Grafana" on Cloud Instance](https://community.grafana.com/t/critical-access-issue-error-loading-grafana-on-cloud-instance/162316)

<div class="topic-metadata">

**Author:** [@abdullahh](https://community.grafana.com/u/abdullahh)\
**Replies:** 0\
**Last updated:** [March 30, 2026, 9:52am UTC](https://community.grafana.com/t/critical-access-issue-error-loading-grafana-on-cloud-instance/162316 "2026-03-30T09:52:08Z")

</div>

What happened? When attempting to access my Grafana Cloud instance via my personalized URL, the application fails to initialize. Instead of the login page or dashboard, I am presented with a white screen and the error me…

---

## [Grafana Dashboard for 100+ Servers (Grid View with Sorting & Filtering)](https://community.grafana.com/t/grafana-dashboard-for-100-servers-grid-view-with-sorting-filtering/162179)

<div class="topic-metadata">

**Author:** [@shyambaseapp](https://community.grafana.com/u/shyambaseapp)\
**Replies:** 4\
**Last updated:** [March 25, 2026, 8:16am UTC](https://community.grafana.com/t/grafana-dashboard-for-100-servers-grid-view-with-sorting-filtering/162179 "2026-03-25T08:16:15Z")

</div>

Grafana Version & Environment Grafana version: 10.x (latest stable) OS: Ubuntu 22.04 Data source: Prometheus Exporter: Node Exporter What are you trying to achieve? I want to build a single dashboard panel …

---

## [Best practice for testing Grafana app plugins without using live production data before publishing?](https://community.grafana.com/t/best-practice-for-testing-grafana-app-plugins-without-using-live-production-data-before-publishing/161604)

<div class="topic-metadata">

**Author:** [@sarika1731](https://community.grafana.com/u/sarika1731)\
**Replies:** 1\
**Last updated:** [February 24, 2026, 11:51am UTC](https://community.grafana.com/t/best-practice-for-testing-grafana-app-plugins-without-using-live-production-data-before-publishing/161604 "2026-02-24T11:51:55Z")

</div>

Hi Grafana community :waving\_hand: I’m building an App Plugin (incident-first reliability / RCA style workflow) that correlates metrics, logs, traces, and Kubernetes context into a guided investigation view. The plugin…

---

## [Building monthly rain visualization via VictoriaMetrics from Home Assistant](https://community.grafana.com/t/building-monthly-rain-visualization-via-victoriametrics-from-home-assistant/161799)

<div class="topic-metadata">

**Author:** [@raptor05](https://community.grafana.com/u/raptor05)\
**Replies:** 0\
**Last updated:** [February 22, 2026, 9:44am UTC](https://community.grafana.com/t/building-monthly-rain-visualization-via-victoriametrics-from-home-assistant/161799 "2026-02-22T09:44:41Z")

</div>

What Grafana version and what operating system are you using? Grafana v12.3.3 on Docker What are you trying to achieve? I’m using VicoriaMetrics to populate some sensor data from Home Assistant to Grafana. I alrea…

---

## [Trouble Using MongoDB Aggregation Query in Alert Rules](https://community.grafana.com/t/trouble-using-mongodb-aggregation-query-in-alert-rules/161679)

<div class="topic-metadata">

**Author:** [@dhatar94](https://community.grafana.com/u/dhatar94)\
**Replies:** 0\
**Last updated:** [February 14, 2026, 10:17am UTC](https://community.grafana.com/t/trouble-using-mongodb-aggregation-query-in-alert-rules/161679 "2026-02-14T10:17:44Z")

</div>

Hi! I’m trying to query a MongoDB data source and use that to set up a few alerts, but I’m struggling to make it work. I have a dashboard with a table view where I filter error codes over a time range and aggregate the…

---

## [$\_\_interval variable is always 60.000s in TimescaleDB query](https://community.grafana.com/t/interval-variable-is-always-60-000s-in-timescaledb-query/161603)

<div class="topic-metadata">

**Author:** [@nicolargo](https://community.grafana.com/u/nicolargo)\
**Replies:** 5\
**Last updated:** [February 9, 2026, 6:07pm UTC](https://community.grafana.com/t/interval-variable-is-always-60-000s-in-timescaledb-query/161603 "2026-02-09T18:07:27Z")

</div>

Hi all, i want to create a simple time series dashboard chart from a TimescaleDB database. For that, i use the $\_\_interval variable: SELECT $\_\_timeGroupAlias(ref\_timestamp, $\_\_interval), AVG(value) FROM database …

---

## [structuredMetadata vs label escaping](https://community.grafana.com/t/structuredmetadata-vs-label-escaping/151756)

<div class="topic-metadata">

**Author:** [@jansykora](https://community.grafana.com/u/jansykora)\
**Replies:** 3\
**Last updated:** [January 29, 2026, 1:49pm UTC](https://community.grafana.com/t/structuredmetadata-vs-label-escaping/151756 "2026-01-29T13:49:07Z")

</div>

I’m using Grafana Loki for storing logs. I am using structuredMetadata for faster lookup. I’m ingesting and reading data to/from Loki via http API. When I want to query by some structuredMetadata that contains escaped ch…

---

## [K6 with Amazon Manged Prometheys](https://community.grafana.com/t/k6-with-amazon-manged-prometheys/131349)

<div class="topic-metadata">

**Author:** [@vanshulsuneja98](https://community.grafana.com/u/vanshulsuneja98)\
**Replies:** 2\
**Last updated:** [December 22, 2025, 11:46am UTC](https://community.grafana.com/t/k6-with-amazon-manged-prometheys/131349 "2025-12-22T11:46:02Z")

</div>

Does Grafana K6 supports output to Amazon Manged Prometheus. If yes, what are the steps for it?

---

## [Convert string to a valid logql query?](https://community.grafana.com/t/convert-string-to-a-valid-logql-query/160297)

<div class="topic-metadata">

**Author:** [@mihalt](https://community.grafana.com/u/mihalt)\
**Replies:** 3\
**Last updated:** [December 17, 2025, 8:25am UTC](https://community.grafana.com/t/convert-string-to-a-valid-logql-query/160297 "2025-12-17T08:25:13Z")

</div>

I have on output string like “{service\_name = “myservice”}”. How can I convert it to a valid logql command exactly inside place where I enter the command in the dashboard panel? I need it to use templating opportunities…

---

## [How to Manage Multiple Devices with Per-Device Sharding & Credentials for Loki / InfluxDB?](https://community.grafana.com/t/how-to-manage-multiple-devices-with-per-device-sharding-credentials-for-loki-influxdb/160099)

<div class="topic-metadata">

**Author:** [@alivan](https://community.grafana.com/u/alivan)\
**Replies:** 0\
**Last updated:** [December 11, 2025, 5:26am UTC](https://community.grafana.com/t/how-to-manage-multiple-devices-with-per-device-sharding-credentials-for-loki-influxdb/160099 "2025-12-11T05:26:28Z")

</div>

Hi everyone, I’m building a system where multiple devices will be sending logs and metrics to Grafana Cloud. Before I proceed, I want to understand the best practices for handling device-level separation and per-device …

---

## [Logs disappear after restarting Loki on ECS with S3 backend](https://community.grafana.com/t/logs-disappear-after-restarting-loki-on-ecs-with-s3-backend/159910)

<div class="topic-metadata">

**Author:** [@tatevhunanyan](https://community.grafana.com/u/tatevhunanyan)\
**Replies:** 1\
**Last updated:** [December 4, 2025, 9:00pm UTC](https://community.grafana.com/t/logs-disappear-after-restarting-loki-on-ecs-with-s3-backend/159910 "2025-12-04T21:00:16Z")

</div>

Hi Grafana community, I’m running Loki on AWS ECS with S3 as the storage backend. My setup has 2 Loki instances using the same config file. Problem: Logs that are ingested disappear from Grafana after restarting Loki.…

[Next page](https://community.grafana.com/tag/query-help/30.md?match_all_tags=true&page=1&tags%5B%5D=query-help)
