Greetings
given the following data
device,current,timestamp
Cell 1,600,2023-08-29 04:04:19.539000
Cell 2,800,2023-08-29 04:04:29.779000
Cell 3,800,2023-08-29 04:04:29.779000
Cell 4,750,2023-08-29 04:04:29.779000
Cell 5,550,2023-08-29 04:30:29.789000
Cell 14,600,2023-08-29 04:04:19.539000
Cell 12,800,2023-08-29 04:04:29.779000
Cell 13,800,2023-08-29 04:04:29.779000
Cell 14,750,2023-08-29 04:04:29.779000
Cell 15,550,2023-08-29 04:30:29.789000
I attempted to sort on my final custom sort column but it still seems to want to sort by device name?
import "strings"
from(bucket: "electric_boogaloo")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_field"] == "current")
|> map(fn: (r) => ({r with my_replace: strings.replaceAll(v: r._measurement, t: "Cell", u: "")}))
|> map(fn: (r) => ({r with my_trim: strings.trimSpace(v: r.my_replace)}))
|> map(fn: (r) => ({r with my_sort: int(v: r.my_trim)}))
|> sort(columns: ["my_sort"])
Is my logic correct here?
