Stack Overflow
Stack Overflow

Questions tagged [grafana-variable]

245 questions
1
vote
1 answer

Grafana select query throwing error - "Found no column named time or time_sec"

I am using Grafana mysql data connector and trying to write a select query. The select query is throwing an error - "Found no column named time or time_sec" Here is the query SELECT main_id, ipaddress FROM table1;
meallhour
  • 13,921
  • 21
  • 60
  • 117
1
vote
0 answers

How to write a Grafana Query to search by a value inside an Array

I am trying to filter/search Grafana logs using a specific value Which is inside a nested array, which only returns empty results. This is how a particular log looks like (I am here only giving a one log out of…
BhagyaKolitha Jayalath
  • 107
  • 1
  • 12
1
vote
0 answers

Single line query for percentage from two different queries in influxdb for grafana

unable to get a query in grafana singlestat panel for influxdb - my queries are from the same field not different field. Example - field name = fieldA query1 = SELECT "fieldA" FROM seriesA WHERE $timeFilter AND ("tag1"='yes') query2 = SELECT…
KSHITIJA MOHAN MURUDI
  • 11
  • 1
1
vote
0 answers

Populating constant value using grafana Table panel plugin

I am trying to generate a dashboard report as below. It has 3 columns (Service uptime list, expected and actual %). I am using Table panel in Grafana and populated first 2 columns using max(up) by (service). Service list is getting populated from…
user7700138
  • 123
  • 2
  • 4
  • 13
1
vote
1 answer

In Grafana, how do I use a variable I made and give it as a value into a query search for a graph?

I am trying to take the value of a drop down I created in grafana, utilizing a query variable. I am using SimpleJSON for my database. I have tried this pattern where: var is my variable that makes up the drop down menu func is my function call for…
user11632040
1
vote
2 answers

How to make Simple-JSON variable template query in grafana?

I am trying to create a dynamic variable for a graph using a kdb+ database, which requires the Simple-JSON plug in. However, I am struggling to figure out how to write the query in the Query search bar under Variables on my Dashboard. I have looked…
user11632040
1
vote
1 answer

Grafana : Compare with same day of the week last year

I have dashboard with a single stat panel showing the number of bookings for the current day. I need to show the same information (in order to compare) for the same of the week for last year on the same dashboard. I know there is the "Time shift"…
Jérôme
  • 31
  • 3
0
votes
2 answers

Grafana Dashboard not showing the mapped values

I have mapped values in my Grafana Dashboards as shown in the following Link: https://grafana.com/docs/grafana/latest/panels-visualizations/configure-value-mappings/ For example: Variable is called Name and it contains the values 1,2,3,4,5 from the…
albdev
  • 43
  • 5
0
votes
0 answers

Grafana filter by name Zabbix query , but by variable

How can I somehow make this work? I have a grafana panel which gets data from Zabbix SQL query, then I extract these dates. My table looks like: x | y | z --+---+-- 1 | 2 | 3 I want to get back only the value 1, if my variable is set to x, on the…
user17070314
  • 1
0
votes
0 answers

How to create a Grafana panel that uses shared queries from a source panel as well as ad hoc queries?

I am struggling to find a way to use in a Grafana panel a Grafana Query variable that contains a list of elements. This is needed in order to optimize the loading time of the dashboard. I have certain variables that are used in multiple panels. One…
Berni Hacker
  • 37
  • 8
0
votes
1 answer

grafana - variable in datasource

I've created several elastic datasources in Grafana Elastic-fido2-${vertical}-events How can I load it based on the $vertical variable so I use the same visual and not one for each $vertical? I found this on grafana forum:…
MortenB
  • 2,749
  • 1
  • 31
  • 35
0
votes
1 answer

How to set Display name in Grafana for a time series line using dashboard variables?

I currently have a dashboard variable dimensionValue defined in my variables, in my dashboard. This query for this variable equates to 2 possible values : ORDS or APEX. I would like to label the lines on a time series graph based on these variables.…
Arun Muthupalaniappan
  • 100
  • 7
0
votes
0 answers

How to use variable in a panel with time series format in Grafana (elasticsearch data source)

I used ElasticSearch as a data source in Grafana 9 and set the metric to “Raw Data” mode, then selected some fields using “Organize Fields Transform” and hid the rest. I also placed the visualization on the “time series”. Now I want to define a…
Hasti
  • 1
  • 1
0
votes
0 answers

Grafana Variable to select Azure resource group and resource select dynamically

I am creating Grafana Variable where has resource group and resource should select dynamically, How can we achieve this in grafana variable or any other way it is possible? Screenshot is below In above screen shot I need to select all resource…
GoneCase123
  • 388
  • 4
  • 15
0
votes
0 answers

How to apply a Grafana time series value to all panels on a dashboard

I have some panels with time series data like, user searches. I wanted to normalize the data by the amount of users created during the same time. I can do it on a panel by panel basis by Adding a new Query for UsersCreated and apply a transformation…
ozhou
  • 105
  • 6
1 2 3
…
16 17