Candlestick, Box chart/plot in Influx UI

InfluxDB 2 Dashboards
1

I am using InfluxDB v2.7.0 & UI from Influx.
Interesting in data visualization using Candlestick,Box chart/plot in Influx UI (data example like @scott speaking in https://youtu.be/h6KYk17FBNk?list=PLEM0QD2CHxaJbAV1DTE8CIh2Exxd10DbK&t=2373).
What is a more simple way to add this custom type of visualization in Influx UI?
Or maybe exist possibility to visualize this type of chart with existed types of visualization?

2

@va2dim The InfluxDB UI does not have a candlestick or box chart visualization. The band visualization is the closes visualization type to that, but it’s probably not what you’re looking for. If you’re able to use Grafana, it does have a candlestick visualization.

Also, the candlestick function I demo’d in that video is not a very optimized function. This definition is much more performant:

candlestick = (tables=<-, every) => {
    _min = tables |> aggregateWindow(fn: min, every: every) |> map(fn: (r) => ({r with _field: "${r._field}_min"}))
    _max = tables |> aggregateWindow(fn: max, every: every) |> map(fn: (r) => ({r with _field: "${r._field}_max"}))
    _open = tables |> aggregateWindow(fn: first, every: every) |> map(fn: (r) => ({r with _field: "${r._field}_open"}))
    _close = tables |> aggregateWindow(fn: last, every: every) |> map(fn: (r) => ({r with _field: "${r._field}_close"}))
    _output =
        union(tables: [_min, _max, _open, _close])
            |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value")

    return _output
}

data
    |> candlestick(every: v.windowPeriod)
3

Unfortunately, we move from Grafana to InfluxDB UI :weary: