Introducing Conversion Functions in KQL
Published Sep 07 2022 05:28 AM 1,310 Views
Microsoft

Are you working with unit measurement data and the data is one unit and you need it another unit?

 

There could be many reasons that you need to convert the value, whether this is due to regional requirements or to simplify for reporting.

 

Great news, the Kusto team have introduced several unit conversion functions to Azure Data Explorer that will help with this.

 

Below you will find the list of unit conversion functions that have been added along with examples.

 

convert_angle - Converts one angle unit to another.

 

Conversion units available for angles:

Arcminute, Arcsecond, Centiradian, Deciradian, Degree, Gradian, Microdegree, Microradian, Millidegree, Milliradian, Nanodegree, Nanoradian, NatoMil, Radian, Revolution, Tilt.

 

Example to convert from Degree to Arcminute:

 

ShafMahmood_16-1661530185990.png

 

convert_energy – Converts one energy unit to another.

 

Conversion units available for energy:

BritishThermalUnit, Calorie, DecathermEc, DecathermImperial, DecathermUs, ElectronVolt, Erg, FootPound, GigabritishThermalUnit, GigaelectronVolt, Gigajoule, GigawattDay, GigawattHour, HorsepowerHour, Joule, KilobritishThermalUnit, Kilocalorie, KiloelectronVolt, Kilojoule, KilowattDay, KilowattHour, MegabritishThermalUnit, Megacalorie, MegaelectronVolt, Megajoule, MegawattDay, MegawattHour, Millijoule, TeraelectronVolt, TerawattDay, TerawattHour, ThermEc, ThermImperial, ThermUs, WattDay, WattHour.

 

Example to convert from Joule to BritishThermalUnit:

 

ShafMahmood_17-1661530185995.png

 

convert_force – Converts one force unit into another.

 

Conversion units available for force:

Decanewton, Dyn, KilogramForce, Kilonewton, KiloPond, KilopoundForce, Meganewton, Micronewton, Millinewton, Newton, OunceForce, Poundal, PoundForce, ShortTonForce, TonneForce.

 

Example to convert from Newton to Decanewton:

 

ShafMahmood_18-1661530186002.png

 

convert_length – Converts one length unit to another.

 

Conversion units available for length:

Angstrom, AstronomicalUnit, Centimeter, Chain, DataMile, Decameter, Decimeter, DtpPica, DtpPoint, Fathom, Foot, Hand, Hectometer, Inch, KilolightYear, Kilometer, Kiloparsec, LightYear, MegalightYear, Megaparsec, Meter, Microinch, Micrometer, Mil, Mile, Millimeter, Nanometer, NauticalMile, Parsec, PrinterPica, PrinterPoint, Shackle, SolarRadius, Twip, UsSurveyFoot, Yard.

 

Example to convert from Meter to Foot:

 

ShafMahmood_19-1661530186004.png

 

convert_mass – Converts one mass unit into another.

 

Conversion units available for mass:

Centigram, Decagram, Decigram, EarthMass, Grain, Gram, Hectogram, Kilogram, Kilopound, Kilotonne, LongHundredweight, LongTon, Megapound, Megatonne, Microgram, Milligram, Nanogram, Ounce, Pound, ShortHundredweight, ShortTon, Slug, SolarMass, Stone, Tonne.

 

Example to convert from Kilogram to Pound:

 

ShafMahmood_20-1661530186006.png

 

convert_speed - Convert a speed value from one unit to another.

 

Conversion units available for speed:

CentimeterPerHour, CentimeterPerMinute, CentimeterPerSecond, DecimeterPerMinute, DecimeterPerSecond, FootPerHour, FootPerMinute, FootPerSecond, InchPerHour, InchPerMinute, InchPerSecond, KilometerPerHour, KilometerPerMinute, KilometerPerSecond, Knot, MeterPerHour, MeterPerMinute, MeterPerSecond, MicrometerPerMinute, MicrometerPerSecond, MilePerHour, MillimeterPerHour, MillimeterPerMinute, MillimeterPerSecond, NanometerPerMinute, NanometerPerSecond, UsSurveyFootPerHour, UsSurveyFootPerMinute, UsSurveyFootPerSecond, YardPerHour, YardPerMinute, YardPerSecond.

 

Example to convert from MeterPerSecond to CentimeterPerHour:

 

ShafMahmood_21-1661530186011.png

 

convert_temperature - Convert a temperature value from one unit to another.

 

Conversion units available for temperature:

DegreeCelsius, DegreeDelisle, DegreeFahrenheit, DegreeNewton, DegreeRankine, DegreeReaumur, DegreeRoemer, Kelvin, MillidegreeCelsius, SolarTemperature.

 

Example to convert from Kelvin to DegreeCelsius:

 

ShafMahmood_22-1661530186014.png

 

convert_volume - Convert a volume value from one unit to another.

 

Conversion units available for volume:

AcreFoot, AuTablespoon, BoardFoot, Centiliter, CubicCentimeter, CubicDecimeter, CubicFoot, CubicHectometer, CubicInch, CubicKilometer, CubicMeter, CubicMicrometer, CubicMile, CubicMillimeter, CubicYard, Decaliter, DecausGallon, Deciliter, DeciusGallon, HectocubicFoot, HectocubicMeter, Hectoliter, HectousGallon, ImperialBeerBarrel, ImperialGallon, ImperialOunce, ImperialPint, KilocubicFoot, KilocubicMeter, KiloimperialGallon, Kiloliter, KilousGallon, Liter, MegacubicFoot, MegaimperialGallon, Megaliter, MegausGallon, MetricCup, MetricTeaspoon, Microliter, Milliliter, OilBarrel, UkTablespoon, UsBeerBarrel, UsCustomaryCup, UsGallon, UsLegalCup, UsOunce, UsPint, UsQuart, UsTablespoon, UsTeaspoon.

 

Example to convert from CubicMeter to AcreFoot:

 

ShafMahmood_23-1661530186016.png

 

 

Please provide feedback if there are any additional conversion functions that you would find useful!

Version history
Last update:
‎Aug 26 2022 09:23 AM
Updated by: