Back to Influxdb

float() function

content/flux/v0/stdlib/universe/float.md

latest3.5 KB
Original Source
<!------------------------------------------------------------------------------ IMPORTANT: This page was generated from comments in the Flux source code. Any edits made directly to this page will be overwritten the next time the documentation is generated. To make updates to this documentation, update the function comments above the function definition in the Flux source code: https://github.com/influxdata/flux/blob/master/stdlib/universe/universe.flux#L3254-L3254 Contributing to Flux: https://github.com/influxdata/flux#contributing Fluxdoc syntax: https://github.com/influxdata/flux/blob/master/docs/fluxdoc.md ------------------------------------------------------------------------------->

float() converts a value to a float type.

Function type signature
js
(v: A) => float

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

v

({{< req >}}) Value to convert.

Examples

Convert a string to a float

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


Convert a scientific notation string to a float

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


Convert an integer to a float

js
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 convert a column value to a float type.

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

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

_timeexampleCol*tag
2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:10Z10t1
2021-01-01T00:00:20Z7t1
2021-01-01T00:00:30Z17t1
2021-01-01T00:00:40Z15t1
2021-01-01T00:00:50Z4t1
_timeexampleCol*tag
2021-01-01T00:00:00Z19t2
2021-01-01T00:00:10Z4t2
2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:30Z19t2
2021-01-01T00:00:40Z13t2
2021-01-01T00:00:50Z1t2

Output data

_timeexampleCol*tag
2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:10Z10t1
2021-01-01T00:00:20Z7t1
2021-01-01T00:00:30Z17t1
2021-01-01T00:00:40Z15t1
2021-01-01T00:00:50Z4t1
_timeexampleCol*tag
2021-01-01T00:00:00Z19t2
2021-01-01T00:00:10Z4t2
2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:30Z19t2
2021-01-01T00:00:40Z13t2
2021-01-01T00:00:50Z1t2

{{% /expand %}} {{< /expand-wrapper >}}