Grafana: Dropdown Variable is not selecting the particular values in Dashboard and Viz

Question

I am having a Grafana Dashboard with Grafana Viz(TimeSeries), When I select particular value in dropdown, stil its showing all values in Grafana Viz.

Grafana Viz SQL Query:

SELECT DATE, impliedVolatility_OPT AS "-",symbol  FROM <db>.<tl>

Grafana Variable(Drop Down SQL Query):

SELECT DISTINCT CONCAT('- ', symbol) AS symbol FROM <db>.<table_name>;

Snap Attached:

Once inspect query in Grafana Viz, Apply Panel Transformation is able to select dataframe of sql query in Multi Frame Transformation

But Varible is not working when selected particular value in Variable.

Oluwafemi Sule · Accepted Answer · 2024-08-04 19:00:33Z

1

You need to apply a filter in your visualization query for the selected value from the dropdown.

The options in the dropdown are prefixed with '-' and you have the symbol variable configured to include All option and multi-value.

You need to filter in a list of values as a result, you can write:

SELECT 
    DATE, impliedVolatility_OPT AS "-", symbol  
FROM <db>.<tl>
WHERE CONCAT('- ', symbol) IN (${symbol:singlequote})

answered Aug 4, 2024 at 19:00

Oluwafemi Sule

39.3k1 gold badge63 silver badges88 bronze badges

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

Comments

Divyank · Accepted Answer · 2024-08-06 07:47:07Z

0

As in my SQL Table I don't have - added infront of symbols.

Now I changed the variables and Vizulization query as below and DropDown is working now.

Variable SQL Query for Dashboard:

SELECT DISTINCT  symbol FROM <db>.<tl>;

And VIZ Query:

SELECT DATE, 
symbol, impliedVolatility_OPT '-'
FROM <db>.<tl>
WHERE symbol IN ($Symbol)

SNap:

answered Aug 6, 2024 at 7:47

Divyank

1,0772 gold badges16 silver badges42 bronze badges