Category "grafana"

A regex in query in Grafana

I am a new developer in Grafana and I would like to have a query that returns a variable having "CA" at the END of its name. I was using SEARCH key code but it

How to display time series data as a bar chart in Grafana?

I'm trying to display a timeseries data as a bar chart but Grafana complains about Bar charts requires a string field This is my query: SELECT COUNT(footage_ty

Grafana exclude values from query with wildcard

I have a grafana query that sums a number of stats, my query looks like alias(summarize(sumSeries(stats.checkout-*.*.*.*.*), '$time', 'sum', false), 'checkout')

How to get _value of two tables into one table?

I'm trying to create a dashboard where i can filter data by gas station location and fuel type. This is my Table from this query: from(bucket: "homeassistant")

Prometheus metric value compared to "crawl Time" in grafana

I have metric that exports "current time" from the device in UNIX time, now I would like to compare that time with "crawling time", but I seem to have some prob

Grafana 8 | Notifications Alert

We did an upgrade to our Loki-stack from version:2.1.0 to version 2.4.1, After the upgrade Grafana Alert Rules are not working previously we were running versio

Grafana, Use of local variable in FLux query

beeing relativ new to Flux, I'm trying to make calculation on rows based on a value (tot) I get in amount. > tot=from(bucket: "stat_tst") |> range(start

Set different maximum values for each field in the Bar Gauge | Grafana

I was trying to set up a dashboard so that I could monitor the number of messages within certain queues. The problem is that in order to create a suitable alert

How to correctly scrape and query metrics in Prometheus every hour

I would like Prometheus to scrape metrics every hour and display these hourly scrape events in a table in a Grafana dashboard. I have the global scrape interval

How to display only positive change in Grafana graph?

I am using kube-stats-metrics with kube_pod_container_status_last_terminated_reason as a gauge. The gauge can be reporter for few minutes even hours. But I just

Time series from Prometheus source: how to set nulls as zero?

Working in Docker Grafana 8.1.5. Using time series graph, I'm plotting a Prometheus Counter source (that has one label) as a time series (by label), and need to

How to monitor the amount of messages in a Kafka topic per day?

I have a Kafka cluster with a topic that receives thousands of messages a day and I want to see how many messages went in the topic per date. I'm using JMX expo

Grafana query to generate a cumulative sum from the same time every day

I need to present a Grafana time series graph starting at 05:00 every day. The time series graph needs to show a cumulative sum of 2 mass flow meters until 05:0

How to import custom dashboards to grafana using helm

I'm trying to understand helm and I wonder if someone could ELI5 to me something or help me with something. So i did run below: helm repo add coreos https://s

How can I add a label to the cadvisor and node-exporter metrics?

My node-exporter metrics are something like: process_cpu_seconds_total{instance="10.1.1.1:8080",job="node_info"} process_cpu_seconds_total{instance="10.1.1.2:80

How to calculate the instant rate of a gauge metric?

How can I calculate the per-second instant rate of increase of the time series in Prometheus or Grafana without using rate() or irate()? This drive function is

Airflow metrics with prometheus and grafana

any one knows how to send metrics from airflow to prometheus, I'm not finding much documents about it, I tried the airflow operator metrics on Grafana but it d

How to link to external sites in a grafana table

How do I create a column of cells that contains hyperlinks to external sites? I'm able to embed the text and pass it in via the data-feed, unfortunately grafana

Sum over time of 1d, limit to last 7d, counter as a value

Let's suppose I have metric purchases_total. It's a counter ( which constantly increases ). I would like to make a table in Grafana which: Shows the last 7 day

Grafana: combining two queries from two prometheus exporters

I have two exporters for feeding data into prometheus - the node exporter and the elasticsearch exporter. I'm trying to combine sources from both exporters into