Retrieve the portal time span and use it inside the kusto query
I am trying to access the time range selected from portal and use it inside the kusto query to show some metric (% uptime of a specific api using our custom logic).
Documents does not mention any variable or function that we will help to access the time range selected from portal.
It would be helpful to have a magic variable to see the time range selected from portal.
Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.
Can't understand why this one is not yet implemented for me this is fundamental. You can get events with min an max timestamp to approximate the range but this workaround is not always helpful. Let's say you want to compute percentage of users sessions activity in selected range. You really can't get the range you selected so this is not achievable.
There is one terrible thing with charting too. The x line is limited to first and last event and not to the selected time range, you may end up getting messed time ranges on the dashboard. I expect that when a time range is selected you see this time range on the chart. Instead you get irritating zoom on timeline so hurting for the eyes.
Azure was released years ago but beware it is still in beta
David McCann commented
This would be very useful if we have parameters that we want to change. For example if we are trying to limit the results by the count, for 7 days this should be different than for 24 hours.