Calculating rates across joined series + backfill, no error and no result

1

image
image.jpg1280×720 180 KB

var errors = batch
|query(’’’ SELECT sum(“metric_value”) FROM “mandiri”.“RAW_OneDay”.“RAW_APPD_TRX” WHERE metric_type=‘error’ ‘’’)
.period(10m)
.every(1m)
.groupBy(time(10m), *)
.fill(0)

var counts = batch
|query(’’’ SELECT sum(“metric_value”) FROM “mandiri”.“RAW_OneDay”.“RAW_APPD_TRX” WHERE metric_type=‘count’ ‘’’)
.period(10m)
.every(1m)
.groupBy(time(10m), *)
.fill(0)

errors
|join(counts)
.as(‘errors’, ‘counts’)
|eval(lambda: ((“counts.sum” - “errors.sum”) / “counts.sum”) * 100)
.as(‘success_rate’)
|influxDBOut()
.database(‘mandiri’)
.retentionPolicy(‘CQ_OneWeek’)
.measurement(‘KAPACITOR_APPD_TRX_SUCCESS_RATE_10m’)