Hello all, I am trying to find the number of pipelines converted into MW2 allowlisted per day. For that I need to divide the number of MW2 allowlisted pipelines by the total number of days in the time range selected. I am trying to do this through “Add Field from Calculation” under transform. I am …

Try this: [image] Change the Min Interval to 1d

[image] Thanks for the reply fadjar340! I tried as suggested but I think I am still not getting what I want. As you can see in the second “Add field from calculation” window under Transform, I am trying to divide the stale pipelines by the number of days in the time range selected but I do not se…

May I see the query to get the metrics?

[image] Yes, I have attached the screenshot of the two queries I have used. Also, for further explanation, I am trying to graph the number of stale pipelines which is done and the number days needed to convert those stale pipelines into fresh pipelines. In order to calculate “the number days neede…

Perhaps you can check this post… [image] The value for auto in group by interval (date histogram) Elasticsearch Just to bounce this thread. Anyone? Also this documentation: [image] Add and manage variables | Grafana documentation Add and manage variables…

[image] Hi, Thanks for all the help! I am thinking of solving the issue by using derivative to find the rate. For now, I am trying to create gauge visualization for the two calculations under “Transform”. I am stuck at it because Grafana is somehow showing the graph for the two queries and not t…

Urgent help about referencing time in transformations

Grafana Configuration

fadjar340 July 21, 2021, 1:06pm 6

Perhaps you can check this post…

Also this documentation:

Topic		Replies	Views
Variable for day / timeframe Grafana	9	12466	January 13, 2021
Count days in selected time range InfluxDB	14	4132	June 1, 2023
How to get number in counter query with grafana? PostgreSQL templating , postgres	1	1174	April 28, 2022
Creating a template variable that gives the time range in ms Grafana	1	948	December 20, 2017
Count days in timeseries range Time Series Panel	3	2900	March 7, 2023

Urgent help about referencing time in transformations

Related topics