I want to subtract 2 values in same column of InfluxDB (with 2 diff. timestamps) or in other words I want to find how much count/value increased since 1 Hour in a column(measurement) but grafana doesn’t support it somehow! I queried the 2 values which I want to subtract in 2 fields with Influxdb queries, but since these are in different timeseries, I cant subtract them. When I use transformation ‘Add field from calculation’, it outputs only NaN or 0! How can I subtract both values with different timeseries? (see below)
InfluxDB Query:
Panel Output:
Please help.
Regards,
Thangz