Questions tagged [grafana-templating]

Add this tag to questions regarding Grafana Templating.

188 questions
0
votes
1 answer

How to define a tags / value query in Grafana 7.4?

I am having some trouble understanding the concept of Value groups/tags in Grafana 7.4.x with MySQL as a data source. My main query gets the Countries SELECT NAME as __text, id AS __value from countries The tags query gets the…
merlin
  • 2,717
  • 3
  • 29
  • 59
0
votes
1 answer

how to show sensor status with grafana and influxdb?

I have grafana to display my sensors data and influxdb to store the data tha come from these sensors. Is it possible to show the status of my sensor on grafana for example i can add a field in influxdb with on or off how to display only on with a…
0
votes
1 answer

Grafana query parsing error with label_values

There are two CouchDB servers and I am using variable in Grafana to visualize some metrics, issue is query with variable end up with wrong prasing: couchdb_server_node_info{instance="10\\.10\\.10\\.199:9984"} I do not why it includes the slash,…
MK83
  • 1,652
  • 1
  • 11
  • 11
0
votes
1 answer

Use variable in MYSQL query Grafana Returns Column Name instead of metrics

I have created a variable named $mypair in Grafana, I have added some options manually and I can view those in dashboard. I select an option (example: AUDCAD). In query part of Graph settings I am entering the below query: SELECT…
0
votes
0 answers

Why briangann-datatable-panel sorting is not working in grafana?

I am working on grafana dashboard with briangann-datatable-panel plugin. Here I am trying to sort by total in ascending order but the sort is not working properly. For Example: Name Total ------------------ user1 1 user2 1 user3 …
Naveen
  • 77
  • 3
  • 22
0
votes
1 answer

Grafana Template Variables Query Giving different results in different version (Grafana 5.0 vs Grafana 7.0)

I am using template variable queries to assign a variable in Grafana. SELECT * FROM jmeter WHERE application =~ /$tag_left/ ORDER BY time asc LIMIT 1 Result JSON of this query…
0
votes
1 answer

Grafana Table next/previous/number per page possible?

I need help! I also reported this on grafana community. I hope someone has this experience with me here. I have a table with couple of rows (per day) with LCD gauge cell display mode each columns. As the Dates grows, it will pile up and they will…
0
votes
1 answer

Script for monitoring Cassandra Cluster

I need to report below metrics for a cassandra cluster at the end of the day Cluster Load (Avg.) No of read requests No. of write requests Read Latency Write Latency Long GC Pauses No. of Connections. These have to be cluster wise and not node…
0
votes
1 answer

Grafana Reference DataSet Variable to Translate Legend Values using Postgres Driver

I have a postgres data-source in Grafana that's normalized which restricts my graph-visualization legend to show only the ID (hash) of my record. I want to make this human-readable but the id -> name mapping is in a different datasource/postgres…
Chrizt0f
  • 314
  • 1
  • 12
0
votes
1 answer

How can I adjust the length of the bars in Statusmap chart in Grafana?

How can I adjust the length of the bars in Statusmap chart in Grafana? I want to show the start and end time for each of the bar. The link shows what I want to achieve. Graph to be achieved
0
votes
2 answers

Grafana: using instance label in title field of stats panel

i’m searching for a possibility to show the instance label (node_boot_time_seconds{instance="***.local:9100"}) in the title field of a stats panel. There is a hover message Template Variables: ${__series.name} ${__field.name} $__cell_{N} /…
0
votes
1 answer

Filter release label only for a specific namespace label

I have a grafana instance that monitors certain releases deployed in a namespace. The namespace is hardcoded in my queries for graphs like jenkins_health_check_score{namespace="build",release="$release"} And I want to filter based on only the…
Jason Stanley
  • 386
  • 1
  • 3
  • 20
0
votes
1 answer

Parsing JSON Response in Grafana

I have a Kubernetes environment and using Grafana to visualise metrics streamed from Prometheus. I have application counters which are not fed to Prometheus. However I am able to view them as a JSON object by using a curl…
Peter Smith
  • 53
  • 1
  • 9
0
votes
0 answers

How to delete lines between different clusters of timestamp in Grafana?

As you can see below: There are a lot of lines between different clusters of timestamp, which is so ugly from my perspective, Could I delete it?
Frank Liu
  • 13
  • 1
  • 5
0
votes
1 answer

How to filter tag values in template variable of Grafana?

all. I'm new to Grafana and I want to get only tag values what I want. For example, As you can see,"23" is a value of tags, I just want to get template variable by "23". But now I get so many template variables so that every time I have to seek…
Frank Liu
  • 13
  • 1
  • 5