Is it possible to set "X Column" to something other than time when creating a scatter plot in InfluxDB 2.0?

Hi,

I’ve written the points test a=2,b=4 and test a=4,b=8 to InfluxDB 2.0, which I’m running using docker.

I’ve used the flux command:

from(bucket: "myBucket")
  |> range(start: -1hr)
  |> filter(fn: (r) => r["_measurement"] == "test")
  |> pivot(columnKey: ["_field"], rowKey: ["_time"], valueColumn:"_value" )
  |> yield()

to get a table with columns for a and b. But when I try to create a scatter plot of “a” against “b”, I can’t seem to change the “X column” to anything other than “_time”? Is this deliberate, or am I doing something wrong?

Thanks for any help.

Jack

Yes it is! If you select customize you can change the x value with a drop down: