Questions tagged [grafana-variable]
245 questions
0
votes
0 answers
Does anyone know how to get query from query inspector in Grafana dashboard using http API via api request?
I'm trying to fetch data from query that is located in Grafana dashboard. I have an idea to get results from dashboard but not from the query inspector in Grafana.
I have fetched data from dashboard but not from the query inspector.
0
votes
1 answer
Grafana Chained variables with Infinity data source displays only first item in the collection variable. Can someone please assist?
Collectionlookup gives only the first list item in the variables. Other list items are not getting displayed with this plugin. Example - CollectionLookup(xyz,6878,abcd,11328,$Application) gives 6878,none. This does not display other item(11328).…

harini k
- 43
- 1
- 6
0
votes
0 answers
Grafana: Math calculation between two panels
I am creating a real time dashboard from performance testing perspective that would fetch data from InfluxDB (mostly client side) and Prometheus (server side). It will have below panels (will look fancier in Grafana, of…

PratikKGupta
- 343
- 1
- 3
- 11
0
votes
0 answers
Grafana: X-Y chart. How to set Series names dynamically
I have the following chart
build by
SELECT DISTINCT ON (kpi, build_id)
kpi as KPI,
build_id AS BUILD_ID,
average_time AS AVERAGE_TIME
FROM WHERE kpi IN (${kpi});
where ${kpi} is multi-value variable that contains kpi values…

Curious koala
- 309
- 1
- 9
0
votes
0 answers
Grafana: DeSelect legend (not Disable) as config
There is Grafana panel for memory for kubernetes Deployment + Pod metrics. In the below image, there is 4 graphs -
Yellow - Total (overall) memory used by Deployment
Green - Average memory used per pod in Deployment
(& 4.) Blue & Red - Memory used…

Ashish Kumar
- 524
- 6
- 18
0
votes
0 answers
Using dashboard variable in JSON query with Elastic Search on Grafana
I work with an ElasticSearch data source on Grafana 7.15. The data source has a field 'id' of which the type is 'keyword'.
I'm trying to use a dynamic variable called 'site' in the JSON query meant to create another dynamic variable, 'id'.
Here is…

Daniel
- 1
0
votes
0 answers
In Grafana when 2 template variables from Prometheus change then 1 template variable from Data Source changes too
In Grafana v9.3.4
I have the following 2 template variables named instance and mssql_instance.
The first one returns the instance (e.g. "winserver") and the second one return the SQL instances of the instance "winserver" (e.g. "mssqlserver", "dev").…

Blax
- 35
- 6
0
votes
1 answer
Declare variable in Grafana query from dashboard variable
I am using a table visualization in Grafana and I want to filter the content of the table with a variable called "PC", of type query, showing a list of PC names.
The SQL sentence that I am using is the following:
DECLARE @cols AS NVARCHAR(MAX),…

Jose Mari Muguruza
- 23
- 7
0
votes
2 answers
build a dashboard in logs counting how many time each log appears
Loki Log click the log screenshot attached
here i have get logs with this query
{namespace="health-helper-stg"} |json | line_format "{{.log}}"
There are multiple logs with different msg types from multiple apps.
So i need to get count of each msg…

Illthizam Nazar
- 1
- 2
0
votes
1 answer
Need help to create a heatmap or time series chart in grafana using bigquery
I am trying to create a heatmap or a time series to display the number of deployments went through out the day on an hourly basis and per environment too in grafana and the data source is bigquery.
Ideally my database has two columns environment,…

Karthik Peddineni
- 81
- 4
0
votes
0 answers
How to map Grafana legend values to ec2 instance names
I realize there have been questions asked about this but I wanted to check that I'm not missing anything. We have hundreds of ec2 instances' cpu usage coming to a Grafana dashboard and I'm trying to update the legend to show the instance name…

frktclr
- 1
- 1
0
votes
1 answer
Bigquery to handle the empty input values with IN operator
I have created a dashboard in Grafana and integrated with Bigquery as a datasource. I have a simple select query to get the count of records from the database which works fine when user selects values from dropdown but when user misses to select the…

Karthik Peddineni
- 81
- 4
0
votes
0 answers
How to config root_url when grafana serve behind reverse proxy such as ingress-nginx
I am now trying to deploy the grafana service under the https://example.com/monitor path, Traffic is coming in through ingress-nginx, here is my ingress-nginx config
apiVersion: networking.k8s.io/v1
kind: Ingress
metadata:
name:…
0
votes
1 answer
Grafana Bigquery query to handle multiple value variable with All option enabled
I have created a Grafana dashboard with filter variables enabled along with "All" option enabled. I am working on BigQuery sql query to fetch the data.
I have constructed below query to fetch the data when "All" option is selected.
SELECT count(*)…

Karthik Peddineni
- 81
- 4
0
votes
1 answer
How to fetch the pod status, container ready status in grafana dashboard for kubernetes cluster in a namespace
I am trying to use the following query:
kube_pod_container_status_ready{namespace="$namespace",pod="$pod",container="$container"}
but not sure of how to set the container variable in grafana. Need help in this one.

Shikha Priyedarshi
- 31
- 4