I do measurements in different testing installations and on different testing batches.
So I filter the measurement data based on two user defined variables called “_installation_id” and “_batch_id”.
I would like to display the measurements using the “Time series” widget.
For this purpose I created the following sql statement:
SELECT pot AS "time", value_desc_varchar AS metric, val_int FROM grafana_data WHERE pot BETWEEN '2021-07-01 07:00:00'AND '2021-07-01 10:00:00' AND installation_id=$installation_id AND batch_id=$batch_id AND value_desc_varchar IN ( 'Temp. oben rechts', 'Temp. oben links', 'Temp. mitte rechts', 'Temp. mitte links', 'Temp. unten rechts', 'Temp. unten links', 'Temp. Schornstein' ) ORDER BY 1
However the widget only displays my data when I do select the appropriate time filter on top of the page. It seems there is some underlaying filtering based on the time filter lies above the sql statement.
How can I manage to show the content using the static selection above (pot BETWEEN '2021-07-01 07:00:00’AND ‘2021-07-01 10:00:00’) without the need to use the time filter in addition to that?
Using the same timeframe as in the sql statement
Using a different timeframe