I am trying to create a % value using a join and map. The joined tables _values are of type int which is how they are stored in InfluxDB. The calculation is always returning an int.
I have tried each of the type conversions which all return internal server error in Chronograf. Looking at the docs it looks like there is a cast function ‘float(value)’ but using this fails to compile the query.
Using InfluxDB 1.7.2 with the built-in Flux.
Is there an updated nightly Flux docker image available? I see there is one on quay.io but it is outdated.