https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/253125#M1134 <P><EM>Summary:&nbsp;This thread explains how to use DQL functions to convert string values into numeric or integer formats. It includes syntax examples and practical use cases for data transformation in Dynatrace dashboards.</EM></P> <P><BR /><BR />Hi Experts</P> <P>May i know which function to use to convert string value in to Integer or Number format?</P> Wed, 21 Jan 2026 10:48:53 GMT nikhilchandra 2026-01-21T10:48:53Z https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/253125#M1134 <P><EM>Summary:&nbsp;This thread explains how to use DQL functions to convert string values into numeric or integer formats. It includes syntax examples and practical use cases for data transformation in Dynatrace dashboards.</EM></P> <P><BR /><BR />Hi Experts</P> <P>May i know which function to use to convert string value in to Integer or Number format?</P> Wed, 21 Jan 2026 10:48:53 GMT https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/253125#M1134 nikhilchandra 2026-01-21T10:48:53Z https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/253129#M1136 <P><a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/47783">@Mizső</a>&nbsp; but i am getting null output, as the input value is a string.</P> Mon, 12 Aug 2024 07:52:23 GMT https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/253129#M1136 nikhilchandra 2024-08-12T07:52:23Z https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/254652#M1161 <P><EM><STRONG>toLong()</STRONG></EM> conversion function , but the string being parameter needs to be a valid number, otherwise you will get null</P><LI-CODE lang="markup">data record(s="1"), record(s="1.2"), record(s="a") | fieldsAdd i=toLong(s), d=toDouble(s)</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="krzysztof_hoja_0-1725183035460.png" style="width: 807px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/22144i644FCBB34500D0E8/image-dimensions/807x568?v=v2" width="807" height="568" role="button" title="krzysztof_hoja_0-1725183035460.png" alt="krzysztof_hoja_0-1725183035460.png" /></span></P><P>&nbsp;</P> Sun, 01 Sep 2024 09:32:03 GMT https://community.dynatrace.com/t5/DQL/Convert-String-to-Integer-in-Dynatrace-Query-Language-DQL/m-p/254652#M1161 krzysztof_hoja 2024-09-01T09:32:03Z