Support for time granularity selected in Azure Portal Dashboard (via bin_auto?)
When adding / pinning an Application Insights or Log Analytics chart to the dashboard, you can use the global time selector on the Dashboard to adjust both the the time range (e.g. past 1 hour, past 7 days) and the granularity (e.g. auto, 5 minutes, 1 hour, etc)
However, that works only for the time range, but not for the granularity.
The reason is that whenever you write a query to render a timechart, you have to hardcode the bin size in the query, e.g.:
requests | summarize count() by bin(timestamp, 1m)
Given the query above, I could now choose the time range in the azure portal (e.g. past 30 days), which works as expected, but the chosen time granularity (e.g. 4 hours) would not be considered as it is still hardcoded to 1minute.
Imho this could be implemented via the bin_auto function, so that you don't need to hardcode the bin size in the query anymore, e.g:
requests | summarize count() by bin_auto(timestamp)
However, this currently does not work and produces an error indicating that "query_bin_auto_size" attribute needs to be set
If Azure Portal would set that "query_bin_auto_size" under the hood, everything would just work as expected
Please add this feature as it is really useful for user. Thanks in advance.
Torben Knerr commented
See also the related question here:
Official docs for bin_auto() here: