Timefilter for mysql query

Grafana Time Series Panel
1

Actually im trying to find the count as of now through mysql query.
If i use timefileter it is prompting to give input ‘to’ and ‘from’ but i want as of now.

Mysql query:
select count(*) from systems where deleted_at is null and device_model_id in(select id from device_models where category=‘SREE’) and plan_id=‘basic’ and created_at<=‘2018-08-13 23:59:59’;

Timefilter query used in grafana:
select count(*) from systems where deleted_at is null and device_model_id in(select id from device_models where category=‘SREE’) and plan_id=‘basic’ and $__timeFilter(created_at);

Please help me how to restrict upto current time. I suppose I’m using the wrong time filter.

1 Like
2

you can use:

$__timeFrom()

$__timeTo()

http://docs.grafana.org/features/datasources/mysql/

3

Or use the time range at the upper right corner in a dashboard to change the from and to range