Re: [influxdb] Re: Sum of Column across series - kapacitor v0.12

2016-10-20 Thread nathaniel
The JoinNode https://docs.influxdata.com/kapacitor/v1.0/nodes/join_node/ will do what you want. Keep in mind that the JoinNode joins on groups, so make sure the .groupBy dimensions match. On Wednesday, October 19, 2016 at 4:50:55 PM UTC-6, Vinit wrote: > > TICKscript: > var running = batch >

Re: [influxdb] Re: Sum of Column across series - kapacitor v0.12

2016-10-19 Thread Vinit Mahedia
TICKscript: var running = batch |query('''select count(value) from "collectd_db"."default".marathon_tasks_value where host =~ /daldevmesoszk01.dev-1/ and instance =~ /amber/''') .period(20s) .every(10s) .groupBy('host') |httpOut('running') var expected = batch |

[influxdb] Re: Sum of Column across series - kapacitor v0.12

2016-10-19 Thread nathaniel
A simple `|sum('emiited')` should work, but its hard to tell without the context of your TICkscirpt. Can you share your TICKscript that is producing that data? On Tuesday, October 18, 2016 at 6:07:12 PM UTC-6, Vinit wrote: > > I have data like this, I want to sum of the column "emitted" across