Continuous Query or Kapacitor - Select Technical Analysis

InfluxDB 2
, ,
1

Hi, is there any way to perform streaming calculations of technical analysis?
I tried following 2 but none of them seem to be working.
Would appreciate it if someone could advise.

  1. Continuous Query
    CREATE CONTINUOUS QUERY “test” on “AAA”
    RESAMPLE EVERY 1s
    BEGIN
    select CHANDE_MOMENTUM_OSCILLATOR(values, 60s) as TA_CMO
    into “BBB”…“bbb”
    from “AAA”…“aaa”
    group by time(60s)
    END

  2. Kapacitor
    stream
    |from()
    .database(‘AAA’)
    .retentionPolicy(‘autogen’)
    .measurement(‘aaa’)
    |window()
    .period(60s)
    .every(1s)
    .align()
    |CHANDE_MOMENTUM_OSCILLATOR(‘values’)
    .as(‘TA_CMO’)
    |influxDBOut()
    .database(‘BBB’)
    .retentionPolicy(‘autogen’)
    .measurement(‘bbb’)
    .precision(‘s’)