Percentage of multiple series in grafana #1302

Closed
opened this Issue Jan 6, 2015 · 12 comments

Projects
None yet
6 participants

aather commented Jan 6, 2015

 I have four series that I need to calculate percentage: Example: A - nonNegativeDerivative(series A) B - nonNegativeDerivative(series B) C - nonNegativeDerivative(series C) D - nonNegativeDerivative(series D) I need to do the following: %A = (A / A+B+C+D x 100) / scaletoSeconds %B = (B / A+B+C+D x 100) / scaletoSeconds %C = (C / A+B+C+D x 100) / scaletoSeconds %D = (D / A+B+C+D x 100) / scaletoSeconds How to perform this task in grafana editor? Thanks for any pointer. Amer.
Member

torkelo commented Jan 6, 2015

 You could do something like this:

Member

torkelo commented Jan 6, 2015

 The divideSeries should be #A. #C

aather commented Jan 6, 2015

 I am getting "Timeseries data request error". Not sure what could be causing it. No value is missing in any of the series.
Member

torkelo commented Jan 6, 2015

 @aather nonNegativeDerivate function does not take a string parameter, only an optional maxValue parameter (defaults to none) http://graphite.readthedocs.org/en/latest/functions.html#graphite.render.functions.nonNegativeDerivative

aather commented Jan 6, 2015

 You are correct! I should have done my homework. Thanks for your patience and willingness to help. It is working great! Regards, Amer.

semutter commented Nov 8, 2016

 I am using grafana v2.0.2, and cannot see such buttons in my grafana web app, may I ask which version of grafana supports this feature
Member

torkelo commented Nov 8, 2016

 What button?

namanjain1993 commented Nov 23, 2016

 when do i put this divideseries query ?? I am using grafana on opentsdb
Member

torkelo commented Nov 23, 2016

 OpenTSDB does not have such a query function

namanjain1993 commented Nov 24, 2016

 Would it be possible to get percentage using two queries (Success/Total) ? For Success- 1 query For Total - 1 query This time we need it from elasticsearch queries from grafana.
1 similar comment

RamithaM commented Jul 5, 2017

 Would it be possible to get percentage using two queries (Success/Total) ? For Success- 1 query For Total - 1 query This time we need it from elasticsearch queries from grafana.
Member

daniellee commented Jul 5, 2017

 @CookieMaya maybe this would work: https://community.grafana.com/t/basic-elastic-search-query/1543/4