App Insights - Empty as zeros

Question

When I use bin(timestamp, 1m) and generate a timechart of it, null values generate a straight line. How can i treat missing values as zeros?!?

Answer 1

Another option is to use the make-series operator instead of summarize, with default=0.

Make-series documentation

make-series creates a series that can be analyzed using advanced time-series functions. It's a bit clunkier than summarize, but offers other advantages.

Answer 2

Your best bet is to use iif() in conjnction with an isnull() or isempty(). Mind you if your pulling from a custom metric you will need to make sure you're value is set to the same type.

requests | extend mycustomvalue = toint(todynamic(customDimension).customDuration) | extend mycustomduration = iif((isnull(mycustomvalue) or isempty(mycustomvalue)), 0.0, mycustomvalue)