Cannot get string to display point on Time Series

Grafana InfluxDB
1

Hello all,

I’m trying to get a data point on a Time series dashboard to show both a code number (specifically 2) which is working, along with a subset value which indicates a direction (south or north). These are two different _fields with two seperate_values in my database, and any attempt to join them succeeds on a table, but when attempting to have both code and direction show on a data point, it only shows the code, so I have no way to differentiate directions (see below:

image

image
image1307×70 3.17 KB

I currently am using an outer join to get the tables to show the data in the table at the same time.

I’m using grafana v9.1.6 with influx2+ and flux.

data = from(bucket: "bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["serial"] == "serial")
  |> filter(fn: (r) => r["_measurement"] == "software")
  |> filter(fn: (r) => r["detection"] != "report")

data
  |> filter(fn: (r) => r._field == "vehicle")
  |> yield(name: "direction")

data
  |> filter(fn: (r) => r._field == "code")
  |> yield(name: "code")
2

can you show a table view of your data?

3

image
image1302×257 7.24 KB

4

Not sure that it is possible if direction is not shown on the same chart. If it is, then it could be done like this:

Time Series
Time Series1911×555 55.1 KB

5

I went with a different method of renaming the string to an integer and then converting and value mapping. Thanks.