I am plotting data from a MySQL datasource in Grafana v7.2.1 in Windows. The data is about different batches. I would like to make two graphs, one of the current batch, using $__timeFilter(time_stamp), and one showing data from a different batch.
I have the batch numbers in a variable called $batch, and I would like these two queries:
select * from example where $__timeFilter(time_stamp);
select * from example where bach_number in ($batch);
Batches have their own time range (beginning and end of batch) and I would like to select * from example within this time range. However, if this is not the time range selected at the top of the dashboard, I cannot see it.
Any ideas?