I installed grafana, but my sql skills are way below the level of the presentation in the documentation regarding my “issue”. Please excuse me if there happens to be a dedicated feature/chapter which exactly would do this. I simply can’t understand/find it there.
I connected my sqlite db file through the sqlite datasource and doing a simple single query of my table like;
SELECT DateTimeStamp, Temperature FROM sensordata
It’s a timeseries table and the DateTimeStamp column is set as a time formatted column.
The table is starting to be big and the query time is taking longer and longer, which is normal because i am doing a complete query of the table.
My question is if there is a way to connect or corelate the relative or absolute timerange
dropdown list elements to query only the selected time range and don’t do a full query then jump to that time range.
I searched for keywords like dynamic, time, range, query on google and here but nothing that i would understand came up.
Thank you kindly and have a nice evening if applies.