What Grafana version and what operating system are you using?
Latest version of grafana and os is windows
What are you trying to achieve?
I am trying to create my own time variable
How are you trying to achieve it?
using variable, values in variable are ‘this week’, ‘this month’, ‘this year’, etc
I am not able to use those values in my SQL query
What did you expect to happen?
Can you copy/paste the configuration(s) that you are having problems with?
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
Did you follow any online instructions? If so, what is the URL?
Hi @mayurvidhwani7387, can you clarify what you’re trying to achieve? Do you want to have a template variable that has a drop-down with text like “this month”, but then values that correspond to the actual bounds of the month, which you can use in a query?
Are you not able to simply use Grafana’s existing time selector? Maybe you can say a few words about why that doesn’t work for you.
Actually, the task which I have been assigned requires me to create our own time variable and not use the Grafana time filter.
Is it possible to create it in Grafana?
I don’t think there’s a great way to recreate the functionality of the time picker using template variables.
There may be a workaround that involves a key-value variable but it would be complex, ugly, and fragile, and I wouldn’t recommend it. Might be better to rethink the necessity of doing this.