Documentation

float() function

float() converts a value to a float type.

Function type signature
(v: A) => float
For more information, see Function type signatures.

Parameters

v

(Required) Value to convert.

Examples

Convert a string to a float

float(v: "3.14")// Returns 3.14

Convert a scientific notation string to a float

float(v: "1.23e+20")// Returns 1.23e+20 (float)

Convert an integer to a float

float(v: "10")// Returns 10.0

Convert all values in a column to floats

If converting the _value column to float types, use toFloat(). If converting columns other than _value, use map() to iterate over each row and float() to covert a column value to a float type.

data
    |> map(fn: (r) => ({r with exampleCol: float(v: r.exampleCol)}))

View example input and ouput


Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.