Forum Discussion

Deleted's avatar
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_, AvailabilityResult == "Fail"), totalCount=sum(count_)
|extend (failedCount / totalCount)
 
but the "extend (failedCount / totalCount)" is just displaying as a 0, its a really small decimal .003...how do I display this as a decimal value?
 
Azure Log Analytics
azure monitor

2 Replies

  • Deleted's avatar
    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.
  • Evgeny Ternovsky's avatar
    Evgeny Ternovsky
    Icon for Microsoft rankMicrosoft
    Mar 05, 2018

    Two valid options:

    1) explicit type casting to floating point:

     

    ... | extend failureRate = todouble(failedCount) / todouble(totalCount)

    2) implicit type casting:

    ... | extend failureRate = failedCount * 1.0 / totalCount

Resources