Questions tagged [grafana-variable]

245 questions
1
vote
0 answers

Grafana data source variables not working in query

I want to call the JSON api with a specific body. Unfortunatelly, the plugin is not using the values of the variables set in the datascources.yaml (provisioning) file. grant_type=password&username={{ .jsonData.user }}&password={{…
G3RRY
  • 11
  • 1
1
vote
2 answers

How can I group many values for a variable in grafana?

I have an SQL table with columns: name and user type. Name type John student Tom teacher Peter teacher Steve student I want to have a grafana variable where I can select a user "type" and the variable passes the value of all the…
Shobhit Kumar
  • 626
  • 1
  • 5
  • 21
1
vote
0 answers

Grafana: How to avoid executing query while zoom in or out?

I have 4 timeseries panels in my dashboard and the query does not have any timefilter in it. So, all the data is fetched. Now, when ever I zoom in or out, these queries are re-executed. Since, they are going to fetch same results, there is no use in…
Selva
  • 951
  • 7
  • 23
1
vote
1 answer

Query using multiples operator OR

I need to write a query that use any of the different tag I define, because the historian database supports only this type of where condition. {tag="pressure" OR tag="level" OR tag="prometheus"} Is it possible to write logical binary operators? I…
1
vote
0 answers

Grafana variable regex returns no results when using MongoDB source

I am creating a variable in Grafana from a mongoDB query. Currently my query returns an array of items in the format of: name="Bob Hansen", id="8051240138eb2ea033aa21f3" name="John Doe", id="4051240138eb2ea033aa21f3" ... Now I am trying to use…
Jolle
  • 1,336
  • 5
  • 24
  • 36
1
vote
0 answers

Grafana - Filter Variable to only show devices reported last X days

In Grafana, I have a variable thats been made using a Query, MTR.test.* This will return to me each device that has ever reported in this path. Now, I would like to filter that data to only show devices that reported in the last X days Is this…
Fimlore
  • 147
  • 1
  • 9
1
vote
1 answer

How to use datetime column as a time series in Grafana using Postgres

Hi guys I have a table in Postgres basically storing a door time entry. for example everytime you scan a card to open a door we store the datetime and your id table format CREATE TABLE doorentry(date CHARACTER VARYING(50),id VARCHAR(255)) dataset…
ak97
  • 15
  • 1
  • 6
1
vote
0 answers

Does Grafana support equality/binary operators in the Variable section?

I'm creating a dashboard to show the canary instance data. I am planning to create a variable that contains the canary instance IPs and we always create one instance in a stack for the canary. So we can assume that if a stack contains one instance…
Roopchand
  • 33
  • 5
1
vote
1 answer

Grafana: How to display RAM by user / service

So on one server, I run 2 nodes and I'm using node exporter to display RAM metrics on Grafana. The issue is that Grafana displays the total RAM usage from the server but I would like to display RAM usage for each node…
1
vote
0 answers

How to use variables in alerts message while creating alert in Grafana(v 8.5.6) using Azure Monitor as a datasource?

I want to create an alert in Grafana (v 8.5.6)and I am using AzureMonitor as a datasource. While creating the alert I am not able to use Resourcegroup, Resource name or Metric Name in the message field of the alert. How to get these values populated…
1
vote
0 answers

grafana dynamic variable use

suppose i want to change the color of the panel text based on a logic for example if active users are 3 and open issue is 6 then since we 2 issue per person color should be yellow and if open issue becomes 9 then then based on active user color…
1
vote
1 answer

How to show dynamic information in Grafana panels

I'm configuring panels in Grafana, but the display shows a little more information than I would like. Ideally, I only want to see the IP address and the value, like this, without the instance ID. At the moment, I'm only able to do this using…
Metro
  • 873
  • 8
  • 19
1
vote
1 answer

Unable to set Disk usage alert on grafana

In multiple VM machine (15+) I use TIG framework (Telegraf, Influxdb and grafana) to monitoring system stats like (CPU, RAM, Disk etc) So data is exported via telegraf and stored in InfluxDB which is further use as datasource in Grafana. The problem…
1
vote
0 answers

How to pass data in Grafana Variables and link it with dashboard API's

So I have a grafana variable .And from the API's it returns alist of ID's. So I have this api that I have linked with a dashboard panel and it requires an id to return a value based on an mrd id. eg. /mrd-stats/?mrdid=23982372489198 . So I don't…
1
vote
0 answers

Add Grafana Variables dropdown to specific panel

I have a grafana variable which is displayed at the top of dashboard. I want this variable dropdown only to appear in a specific panel .eg some where inside the panel .Not at the top of the dashboards. as I have several panels in that dashboard and…