How to set up filters for Grafana Dashboard

Modified on Tue, 12 Nov, 2019 at 6:07 AM

Introduction

Filters are used to generate and send custom reports based on a single dashboard. For example, kindly find the use cases below.


Use Case

Use case: Displays the issues aggregated by the IP based on Geo destination.

Top Vulnerabilities: Displays the percentage of most common issues reported by the IP from a Geo Destination.

Most Vulnerable IP: Displays the highest percentage of the reported issue.

Vulnerabilities by Severity: Displays issues by the severity assigned by the vulnerability scanner.

Notification: Email



How it Works

Grafana users can create template variables for the Dashboard and use variables in metric queries and in panel titles. So when you change the value, using the drop-down at the top of the dashboard, your panel’s metric queries will change to reflect the new value.

To isolate the issues based on IP address and Geo Destination. Users can create Filters inside Skedler Reports to pass a query solution that binds to the Grafana dashboard.


1. Create a Filter in Skedler reports based on the template variables assigned for the particular Grafana dashboard as shown below,

Create filters in the following format,

variableName: value

For example, 

srcIp: geo.dest



If you would like to assign multiple values for the same variable name, separate values using ',' as shown below,

variableName: value1, value2

For example, 

dstCountry: Italy, Simbario



If you would like to use multiple variable name separate the variable using "|" as shown below,

variableName1: value1, value2 |  variableName2: value1

For example, 

dstCountry: Italy, Simbario | srcIp: geo.dest 





2. Schedule a report based on Grafana dashboard and use the created filter query in Select Filter section


3. Save the report.


Post saving the report you can use the mail now option to view the changes in the dashboard. The applied Filter changes the dashboard metrics by passing the query solution which binds to the Grafana dashboard.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article