I set up a custom metric with the steps from this link:

https://learn.microsoft.com/en-us/azure/azure-monitor/agents/data-collection-log-text?tabs=portal

It works to a degree. I get the data in log analytics that was taken from a text file on a dhcp server.

The problem is I can’t convert the strings to int within KQL. When converting it, it appears blank in the column. With gettype() on it, it says string. tostring also will display the number as a string, but toint, tolong, it all appears blank. I tried toint(tostring(Free)) as well. Is there any alternative way to convert the value?

Tried converting string to INT and expected INT but it was blank