azurekqlazure-monitoringazure-dashboard

Azure dashboards - timeline graphs stop at last log record instead of current time


We are creating a dashboard that shows us number of exception on a given system over a time window - specifically, the last 24 hours. The graph looks like this:

enter image description here

If you look closely though, the last bar is a day ago, and not today (See time generated on the last bar in the graph - 12/08/2022, but today is 12/09/2022).

This also occurring on some of our other graphs. Is there someway to get the dashboard to understand that this is a timeline, and always show the right most entry as "Now"? This is quite misleading - we ended up spending a bit of time trying to figure out why the issue wasn't solved. Turns out it was.

Reason why it is happening is because there have been no exceptions that happened since the last error (Yesterday).

Kusto query looks like this:

AppExceptions
| order by TimeGenerated desc 
| where Properties.MS_FunctionName in ("WebhookFlow")
| summarize Exceptions=count() by bin(TimeGenerated, 15m)
| render columnchart with (title="Webhook exceptions")

Solution

  • make-series operator

    AppExceptions
    | where Properties.MS_FunctionName in ("WebhookFlow")
    | make-series Exceptions=count() on TimeGenerated from bin(ago(1d), 15m) to now() step 15m
    | render columnchart with (title="Webhook exceptions")