Hello,
not sure if I am in the right chatroom and sorry if not…
I am using Grafana with the influxDB for counting TRUE events. But somehow I get different results if I SELECT field(alarm)distinct():
0:Array[1522220400000,true]
1:Array[1522311600000,false]
2:Array[1522402800000,false]
3:Array[1522767600000,false]
4:Array[1522857600000,false]
5:Array[1523131200000,false]
6:Array[1523313600000,false]
7:Array[1523404800000,false]
8:Array[1523496000000,false]
9:Array[1523587200000,false]
10:Array[1523677200000,false]
11:Array[1523768400000,false]
12:Array[1523859600000,false]
13:Array[1523950800000,false]
14:Array[1524040800000,false]
it differs from SELECT field(alarm)count():
0:Array[1522220400000,1]
1:Array[1522311600000,1]
2:Array[1522402800000,1]
3:Array[1522767600000,1]
4:Array[1522857600000,1]
5:Array[1523131200000,1]
6:Array[1523313600000,1]
7:Array[1523404800000,2]
8:Array[1523496000000,1]
9:Array[1523587200000,1]
10:Array[1523677200000,1]
11:Array[1523768400000,1]
12:Array[1523859600000,1]
13:Array[1523950800000,1]
14:Array[1524040800000,1]
Does anybody have an idea why the row number 7 (7:Array[1523404800000,2]) returns number 2 for the count()? There should be one as there was no alarm event…
Thanks a lot for any advice