ERROR: cannot perform derivative

Trying to setup detection w/ haproxy, here is the default influxdb query that ships w/ the default haproxy adapter:

SELECT non_negative_derivative(last("http_response.2xx"), 1s) AS "2xx" FROM "telegraf"."twoweeks"."haproxy" WHERE time > :dashboardTime: AND "host" = :host: GROUP BY time(:interval:)

I'm trying to convert that to a TICKs script:

var data = stream
|from()
.database(db)
.retentionPolicy(rp)
.measurement('haproxy')
.groupBy(groupBy)
|window()
.period(period)
.every(every)
.align()
|log()
|derivative('http_response.2xx')
.nonNegative()
.as('value')

I'm getting an error in the log: ERROR: cannot perform derivative

The log() is showing the data, it's all there. Just not sure what is causing this error.

Start by comparing the InfluxDB derivative query with the TICKscript pipeline, especially the window and derivative stages, and use the log() output to narrow down the failure. Check how the derivative stage handles the haproxy measurement and the http_response.2xx field. Done means the cause of the error is identified and derivative processing succeeds for this data.

Written by the indexing model from the issue text.