Summation of segments

Fluxlang
1

Hi,

I’m trying to achieve a summation on ‘segments’, but failing to do so. I hope somebody can help me out in the right direction.

What i’m trying to achieve is : ( for example )

image
image1265×433 27.3 KB

Calculate the sumation of the max value :

segment 1 : 3000
segment 2 : 3133
segment 3 : 3128
segment 4 : 3199
segment 5: 3252

The total of this is 15712, and is what i’m trying to achieve.

Currently my flux script looks like :slight_smile:

data = from(bucket: "....x")
    |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
    |> filter(fn: (r) => r._measurement == "${DeviceID}" and (r._field == ".....x"))
    |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
    |> filter(fn: (r) => r......x> 0 )
    //|> yield(name: "squared")
data1 = data 
    |> derivative(columns:[".....x"],unit: 10s, nonNegative: false)
    |> filter(fn: (r) => r......x> 100 )
    |> set(key: "Type",value: "TotalWeight")
    //|> yield(name: "test") 
 
union(tables: [data, data1])
    |> pivot(rowKey:["_time"], columnKey: ["Type"], valueColumn: "....x") 
    |> filter(fn: (r) => r.TotalWeight > 0 )
    //|> cumulativeSum(columns: ["null"])

I’ve tried using the cumulativeSum function, integral funtion etc etc… but not getting the result im looking for.

I hope someone can help me out.

Thanks,
Regards

2

Hello @bart1992
This is sort of related to this:

It’s very hard to tag events with Flux in InfluxDB or reset a count.