Forum Discussion

Deleted

Mar 04, 2018

Decimal amount not displaying in log Analytics query

Hi I have a really simple query ApplicationInsights | where TelemetryType == "Availability" |summarize count() by AvailabilityResult |summarize failedCount=sumif(count_, Availabili...

Azure Log Analytics

azure monitor

Deleted

Mar 05, 2018

|summarize count() by AvailabilityResult

|summarize failedCount=sumif(count_, AvailabilityResult == "Fail")+0.00000, totalCount=sum(count_)+0.00000

|extend avail=100 - ((failedCount / totalCount)*100)

adding by this decimal forces a cast to decimal.