Questions tagged [grafana-variable]

245 questions
2
votes
2 answers

Temperature unit conversion in grafana

Is there a way to convert temperature from Celcius to farenheit and vice versa using grafana. I tried manipulating f(y) value but I'm looking more for drop down user control to achieve this. Any help is appreciated!
tourist
  • 4,165
  • 6
  • 25
  • 47
2
votes
2 answers

How to nest variables in grafana?

I have a simple Custom variable called route with e.g. this value: /foo/bar,/foo/baz,/foo/baz/foo I'm trying to map these values to some more understandable values, e.g. Custom route_names: bar,baz,foo Searching on google resulted in people doing…
user2084865
  • 625
  • 1
  • 7
  • 18
1
vote
1 answer

How to create a Grafana variable that uses only one element of a Grafana query variable containing a list

In order to improve the performance of my dashboard, I would like to find a way to create a Grafana variable by using another Grafana variable that contains a list of elements. The source variable is room_ids, which is a Query variable that uses a…
1
vote
3 answers

GRAFANA db query error: pq: column "name" does not exist

I am trying to get some graph about different entries in a column in Grafana, but Grafana tries to recognize the antry as a column instead of a column value. I have the following setup: A PostgreSQL Database (v11). A table called People. This table…
albdev
  • 43
  • 5
1
vote
1 answer

postgresql + grafana panel implementation question

i have the following table in a postgresql database, there is a script running every 5 minutes inserting this values in the table. name(varchar) used(int) time(timestamptz) monitoreado1 100 2023-07-19 10:59:15 monitoreado2 200 2023-07-19…
1
vote
1 answer

Querying multiple values inside textbox variable with postgreSQL

I am building a simple Grafana dashboard that would act as a (simplified) DB client for our support team. One of the important queries is an output based on a list of input values. I want to construct a variable + query so that: For variable1 a…
1
vote
1 answer

Grafana variables - how to display selected value and label

I have a Grafana dashboard variable named items. The variable is filled with data coming from an API using JSON API data source. My API response is an array of objects containing two properties: id and name and I have set the name to be the label of…
1
vote
0 answers

Trouble with Dividing Series in Grafana: Blank Screen Issue

I'm currently facing an issue in Grafana (datasource: Metrictank) that I'm hoping to get some guidance on. The problem occurs when I'm attempting to divide two series - 'Series B' (Total number of errors) by 'Series A' (Total count). My query also…
1
vote
2 answers

Showing the Difference between 2 sources / queries in Grafana

At the minute I have 2 lists of data from 2 different queries and sources, for example I have: Source 1 Red Blue White Green Black Source 2 Red Blue Black I want to be able to compare the 2 and show the ones that are missing from Source 2 (White…
user2572639
  • 55
  • 1
  • 11
1
vote
0 answers

Grafana - repeat query for each variable

I have a dashboard parameter named items. I have a datasource HTTP request (using Infinity and / or HTTP JSON API) that sends a request containing an itemId in the query parameter. Now, since I don't know the number of items in my Grafana dashboard…
1
vote
2 answers

Match with capturing groups inside of lookaheads

I have following texts: elasticsearch_sync_queue_lowerlevelgiberish_ManualAllocationPolicy:pending elasticsearch_sync_queue_SynchronizationProcessor:processing I'd like to extract text and value like: text=ManualAllocationPolicy…
bilak
  • 4,526
  • 3
  • 35
  • 75
1
vote
1 answer

Grafana query variable regex replacement

Hello I'd like to create a variable with label_value and then replace the label by some regexp. The value should be entire string, the text should be only part which starts with uppercase (e.g. ManualAllocationPolicy:pending. I guess the regular…
bilak
  • 4,526
  • 3
  • 35
  • 75
1
vote
1 answer

One graph from many metrics in one query

I have a large number of custom metrics like: Request_GetData_XXXX_duration_seconds_sum Request_GetData_XXXX_duration_seconds_count Request_GetData_YYYY_duration_seconds_sum Request_GetData_YYYY_duration_seconds_count Their number and names (XXXX…
1
vote
1 answer

Grafana: X-Y chart. How to represent data with separate lines for multi-value variable

I have chunks of data for each build that I want to visualize with Grafana X-Y chart. Let's say (simplified): kpi average_time build_id Start App 150 870 Stop App 890 870 kpi average_time build_id Start App 140 871 Stop…
Curious koala
  • 309
  • 1
  • 9
1
vote
0 answers

Filter variable values in grafana with dependent variable

I have two variables: Hostname: host1, host2, host3 Process: processA, processB I'd like to restrict the values the user is able to select on the graph depending on the process that is selected. For example, if the process is processA let's only…
Santiago
  • 379
  • 3
  • 14