Hi all, so I’ve created templating to get a name from a column, which works fine as it’s a select statement that brings up the list.
What I’m wanting to do now is to actually change the value being selected as a template
SELECT UNIX_TIMESTAMP(r.created_at) as time_sec, r.`rsi_5_min` as value, e.name as metric
rsi_5_min I have different time periods here such as 5, 15, 30 min and 4hour and 1 day.
I’d like for this to be a template that the user can choose on the Dashboard instead of having to create 5 separate dashboards to have the different interval options.
Is this possible? As I can’t seem to find a way to bring this up as it’s not the results of an sql statement
I am using Grafana 4.6.2 and MySQL as a main datasource.
Thanks a lot.