$__timeInterval in variables/annotations is always 00:00:01

[Dammi87]

Using the $__timeInterval in a variable query can be quite handy, however it seems it doesn't update at all when time-range is changed. In an effort to capture this behaviour I created this variable.

Then, if look at what happens when we make a table with this query

datatable(timeInterval: timespan, variableInterval:string)[
    $__timeInterval, '$_grafanaInterval'
]
| project timeInterval, totimespan(variableInterval)

Notice that there is no change to the variable when changing the time-range, even after a refresh.

1hr

24hr

I noticed this when working with the annotations and saw that they weren't being grouped according to the current binSize in use.

Tested on

• Grafana version 7.2.0
• ADX plug-in version 3.1.0.

[joshhunt]

These ADX macros are only evaluated in the backend, but template variables are evaluated, so the $__timeInterval macro cannot be used in template variables.

[joshhunt]

We'll tag this as a feature request and look at how we can support this in the future

[Dammi87]

@joshhunt Is this feature request archived or is it only the project board? :)

[joshhunt]

Just the old project board. The team will still assess this feature request.