How to create a Slider Dashboard variable/filter in Grafana

Grafana
, , ,
5

This is the variable query, bar chart panel query & data manipulation panel query

Dashboard Variable :-

Name: year

Query:
SELECT year FROM india_population_data;

Bar Chart Panel :-

Data Query:

SELECT
country,
year,
total_population
FROM india_population_data
WHERE
(“year” IN (‘$year’) OR ‘$year’ = ‘year’ OR ‘$year’ IS NULL)

LIMIT 50

Data Manipulation Panel:-

Form Element:

Id: year
Label: year
Type: Number Slider
min: 1960
max: 2022
step: 1

Update Request code:

onChange(elements.map((element) => {
if (element.id === ‘year’) {
$year = element.value; // Set the dashboard variable “year” to the value of the form element “year”
}
return element;
}));