Hi, I would like to display in e.g. gauge graph what is in % the pass rate (from total). Due to that I have created 2 queries where the 2nd one should be in % of the 1st one. In an video I have seen that this is possible but in my case it does not work and it is might because I am using influxDB? …

You will have to use influxdb subqueries, enter query editor raw mode use query menu (next to trash can). Not sure what you want can be done in via subquery though, but maybe

[image] torkel: influxdb subqueries Hello, thank you VERY MUCH for fast answer. I will check now. Cheers, Emilija

Hi again, sorry but can you perhaps help me as I really got stuck :slight_smile:! I have a query A which is showing me the number of successful builds SELECT count("build_result") FROM "jenkins_data" WHERE ("project_name" =~ /^$project_name$/) AND ("build_successful" = '1') AND $timeFilter GROUP …

You may find this plugin useful in your case: Meta Queries plugin is built as a data source plugin and can be used in conjunction with other data source to show computed metrics like Moving Average, Time Shift. . It is not in official grafana plugins repo, you’ll have to install it manually from gi…

Did you found any work around for this issue. I have similar requirement, where have to show the percentage of API statistics in selected duration.

TL;DR: The query you need is: SELECT 1 - mean("isFail") FROM (SELECT "build_result_ordinal"/"build_result_ordinal" AS "isFail" FROM "jenkins_data" WHERE ("project_name" =~ /^$project_name$/) AND $timeFilter) WHERE $timeFilter Although this reply is quite late, this solution should be helpful for …

Using 2 queries for influxDB

emilijathuerlemann December 19, 2017, 9:17am 7

Hi,
no… i have got info that I can use a plug-in for that but that does not work. So I still need help.

Cheers,
Emilija

Topic		Replies	Views
How to do mathematical operations to two queries of influxdb in grafana	2	8953	April 1, 2020
Having difficulty with subqueries Grafana	0	304	June 26, 2020
InfluxDB: Total percentage of entries where a given field is > 0 InfluxDB query-help	1	1583	October 14, 2021
How to display proportion between two values	5	19386	October 20, 2018
How to use Influxdb subqueries in grafana	5	14946	March 28, 2017

Using 2 queries for influxDB

Related topics