Hi I have a problem with flux I can’t seem to solve.
I have a set of data of an experiment which i want to pivot around a specific value:
|> range(start: -200d)
|> filter(fn: ® =>
r._measurement == “MessageLog” and
r.experimentId == “1040” and
r.messagetype == “vr.progress”)
|> filter(fn: ® => r.sequence_name == “Sequence3”)
|> sort(columns: ["_time"], desc: true)
For the now created column the value of the bool “repetition_result2_success” should be true but returns false (not gonna paste it as it is a line with 97 values)
I have double checked this with influxQL and a seperate flux statement, which confirms, that the value is, in fact, true.
Interestingly, I use the same statement above for other datatypes as and these values seem to be correct, it only occurs with boolean values.
I essentially want the following statement from influxQL, only in FLUX:
select * from cobotdb.autogen.MessageLog where “experimentId” = ‘1040’ and “messagetype” = ‘vr.progress’
This statement works correctly, the flux equivalent does not. Did I do something wrong here?
I use the c# API (https://github.com/influxdata/influxdb-client-csharp) with Influx 1.81