How to filter grafana dashboard with greater than and less than operators?

Question

I'm working on a project where I'm using Grafana and InfluxdB. I was able to get all the required values to grafana.

In my response I have a filed with value less than and greater than zero. I want to add a filter where user can select the type of operation.

Any recommendation on how to crack this.

So far I have tried..

I created a Variable (constant value 0, which i tried to use in my dashboard query with less than or greater than operator. As soon as I select my variable, the operator gets changed to 'equal to' or 'not equal to'.

By providing the value directly in the query works fine.

Query reflected Using the variable which i created as constant

SELECT "servicename" AS "Service Name", "topic" AS "Topic", "type" AS "Type", "count" AS "Count" FROM "KafkaLag" WHERE ("servicename" =~ /^$servicename$/ AND "topic" =~ /^$topic$/ AND "type" =~ /^$type$/ AND "count" =~ /^$Greater_than_zero$/) AND $timeFilter ORDER BY time DESC

Query reflected using value directly without any variable

SELECT "servicename" AS "Service Name", "topic" AS "Topic", "type" AS "Type", "count" AS "Count" FROM "KafkaLag" WHERE ("servicename" =~ /^$servicename$/ AND "topic" =~ /^$topic$/ AND "type" =~ /^$type$/ AND "count" > 0) AND $timeFilter ORDER BY time DESC

From the below table I need a way to put a dynamic filter on field_2 where I can get greater than zero values when required.

time | field_1 | field_2 
  t1 |   v1    |    0 
  t1 |   v2    |    2 
  t2 |   v3    |    0 
  t2 |   v4    |    12

Steephen · Accepted Answer · 2019-06-19 01:21:54Z

1

select * from <table/measurement name> where field_2 > 0;

This query will filter data as per you need.

answered Jun 19, 2019 at 1:21

Steephen

16k7 gold badges46 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ashwin Over a year ago

Steephen, this will restrict from the query side. I'm trying to have a more dynamic query, where in future i can increase my list of filter like (0,100,150,200).

David Buck · Accepted Answer · 2020-04-21 14:19:15Z

0

This may be late answer but this is how I have done it earlier. Create a variable count, type "custom". Then, use that variable as below in query-

SELECT "service_name" FROM service  WHERE ("count" >=$count) AND $timeFilter

edited Apr 21, 2020 at 14:19

David Buck

3,87740 gold badges54 silver badges73 bronze badges

answered Apr 21, 2020 at 11:55

user3051413

1

Collectives™ on Stack Overflow

How to filter grafana dashboard with greater than and less than operators?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related