Unable to join data in TICK script

InfluxDB 1 Kapacitor
10

Hi @BhanuKiran,

This appears to be a way the join handles the batched points, but this can be fixed by utilising last().

var period = 10s

var every = 10s

var tolerance = 10d

var hourlyAverage = batch
    |query('''SELECT mean(usage_user) AS usage_user FROM "telegraf"."autogen"."cpu"  WHERE cpu = 'cpu-total' ''')
        .period(1h)
        .every(every)
    |last('usage_user')
        .as('usage_user')

var weeklyAverage = batch
    |query('''SELECT mean(usage_user) AS usage_user FROM "telegraf"."autogen"."cpu"  WHERE cpu = 'cpu-total' ''')
        .period(7d)
        .every(every)
    |last('usage_user')
        .as('usage_user')

hourlyAverage
    |join(weeklyAverage)
        .as('hourlyAverage', 'weeklyAverage')
        .tolerance(1s)

Thanks for your patience, hope this helps!

2 Likes