Downsampling/Aggregation with selection of data

Hi all,
i’m neewbe on influxdb and i need a bit of help.
What i need is a simple downsampling from 1sec to 1h after 28 days with some “selection” and i need to maintaine the data in the same measurament.
This is my measurament

measurament : {
“tag1”,
“tag2”,
“field1”,
“field2”,
“field3”
}

What i mean with “selection” is that i need to downsampling the data with the same tag1 and tag2 and where f1 is less then a value.
Eg:
raw measurament
tag1 tag2 field1 field2 field3
T11 T12 F11 F12 F13
T11 T12 F21 F22 F23
T21 T22 F31 F32 F33
T21 T22 F41 F42 F43

downsampled measurament
tag1 tag2 field1 field2 field3
T11 T12 F11+F21 F12+F22 F13+F23
T21 T22 F31+F41 F32+F42 F33+F43

Is that possible using CQ and RP?

Thanks

1 Like