Field/value is making measurements showing up seperately

homemonitor · March 8, 2024, 3:47pm

I have some software running at home (EVCC) which enables me to charge al my solar energy in my EV.
EVCC stores this info in InfluxDB and I want to be able to show some of that data on a dashboard in Grafana.

Specifically I want to be able to visualize the amps per phase as you can see below, but instead of showing 6 bars, I just want the 3 of the relevant phases at that time. I have the feeling I need to be able to make those phases/data variables so I can pull them up but my knowledge of Flux doesn’t get me far.

Unfortunately the query returns data in such a way it also includes field of “the car currently charging”.
So if you select a timeframe where the car was not charging you get 2 x 3 bars because vehicle = null and car == i4.

I also can’t query for that car only because at any given time some other car can be charging here.

How can I drop the returned field (am I using the correc term?) AND make sure they are all being return as fields which I can nicely format in Grafana? Because {Voortuin} is not really “nice”.

yosiasz · March 8, 2024, 8:11pm

please post schema of your bucket as well as sample data as csv or line protocol?

homemonitor · March 11, 2024, 2:15pm

@yosiasz how can I do that the most practical way? Happy to hear your advise.

yosiasz · March 11, 2024, 2:46pm

Click on that csv button on the flux dashboard yoi shared and post content

homemonitor · March 11, 2024, 3:34pm

#group,false,false,true,true,true,true,true,true,false,false
#datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,string,string,string,string,double,dateTime:RFC3339
#default,mean,
,result,table,_start,_stop,_field,_measurement,loadpoint,vehicle,_value,_time
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,0.4490000307559967,2024-03-10T17:10:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.444262760584472,2024-03-10T17:20:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.696367184321085,2024-03-10T17:30:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.579882790060605,2024-03-10T17:40:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.84434932886168,2024-03-10T17:50:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.806094259023666,2024-03-10T18:00:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.576000436147053,2024-03-10T18:10:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,11.53783384958903,2024-03-10T18:20:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,14.633667373657227,2024-03-10T18:30:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,14.594100697835286,2024-03-10T18:40:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,14.772867361704508,2024-03-10T18:50:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,14.671434052785237,2024-03-10T19:00:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,14.858234087626139,2024-03-10T19:10:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,11.19437550008297,2024-03-10T19:20:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,11.220641551873623,2024-03-10T19:30:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,11.1111172358195,2024-03-10T19:40:00Z
,0,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,Polestar Buz,10.708069488920014,2024-03-10T19:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.722960262298584,2024-03-04T21:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.715547879536946,2024-03-04T21:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.732466920216878,2024-03-05T04:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.73756031036377,2024-03-05T04:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.744518827508997,2024-03-05T04:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.7269233373495245,2024-03-05T04:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.753231030244094,2024-03-05T05:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.726120262145996,2024-03-05T05:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.712047826676142,2024-03-05T05:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.712354451417923,2024-03-05T05:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.717350284258525,2024-03-05T05:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.709200270970663,2024-03-05T05:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.700119302386329,2024-03-05T06:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.6969679863222185,2024-03-05T06:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.708678824560983,2024-03-05T06:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.693052869094045,2024-03-05T06:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,2.9983751326799393,2024-03-05T06:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.733444743686253,2024-03-05T17:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.734031498432159,2024-03-05T17:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.728566980361938,2024-03-05T17:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.730300299326578,2024-03-05T17:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.7129002412160235,2024-03-05T17:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.727033599217733,2024-03-05T18:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.73310030301412,2024-03-05T18:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.72170025507609,2024-03-05T18:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.718486760113691,2024-03-05T18:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.28141713142395,2024-03-05T21:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.28944169773775,2024-03-05T21:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.285322053091866,2024-03-05T21:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.306148670337818,2024-03-05T21:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.302815472638166,2024-03-05T22:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.316296754059968,2024-03-05T22:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.31281531298602,2024-03-05T22:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.30566722468326,2024-03-05T22:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.302964210510254,2024-03-05T22:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.310467190212673,2024-03-05T22:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.307844988505046,2024-03-05T23:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.334667205810547,2024-03-05T23:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.32557201385498,2024-03-05T23:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.337682290510697,2024-03-05T23:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.309567101796468,2024-03-05T23:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.325800482432047,2024-03-05T23:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.31729684052644,2024-03-06T00:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.327421589901572,2024-03-06T00:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.326542139053345,2024-03-06T00:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.31396053314209,2024-03-06T00:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.339083862304687,2024-03-06T00:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.33473383585612,2024-03-06T00:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.325586795806885,2024-03-06T01:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.32252322543751,2024-03-06T01:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.357400491502549,2024-03-06T01:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.333659692244096,2024-03-06T01:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.328946397111222,2024-03-06T01:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.330033906300862,2024-03-06T01:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.357226433292512,2024-03-06T02:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.319833914438883,2024-03-06T02:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.310233879089356,2024-03-06T02:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.336267153422037,2024-03-06T02:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.329071964536395,2024-03-06T02:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.329138492715769,2024-03-06T02:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.317925039327369,2024-03-06T03:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.334483846028645,2024-03-06T03:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.340933879216513,2024-03-06T03:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.332143357821874,2024-03-06T03:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.333805433133753,2024-03-06T03:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.342700576782226,2024-03-06T03:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.33196725845337,2024-03-06T04:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.329200490315754,2024-03-06T04:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,11.323500601450602,2024-03-06T04:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.785533634821574,2024-03-06T07:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.763033596674601,2024-03-06T07:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.749928826377506,2024-03-06T07:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.774133610725403,2024-03-06T07:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.634914520808628,2024-03-06T07:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.523370654494674,2024-03-06T17:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.729774521243188,2024-03-06T17:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.740500275293986,2024-03-06T18:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.728500306606293,2024-03-06T18:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.726533603668213,2024-03-06T18:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.748900270462036,2024-03-06T18:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.750066979726156,2024-03-06T18:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.744745357363832,2024-03-06T18:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.74140027364095,2024-03-06T19:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.732615663455083,2024-03-06T19:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.74175582461887,2024-03-06T19:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.728935718536377,2024-03-06T19:30:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.736200300852458,2024-03-06T19:40:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.736566972732544,2024-03-06T19:50:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.730266904830932,2024-03-06T20:00:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.724900261561076,2024-03-06T20:10:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.723300250371297,2024-03-06T20:20:00Z
,1,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l1,chargeCurrents,Voortuin,i4 Mario,5.731533575057983,2024-03-06T20:30:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,0.4345000237226486,2024-03-10T17:10:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,10.839705443773113,2024-03-10T17:20:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.374850527445476,2024-03-10T17:30:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.242667272979139,2024-03-10T17:40:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.005070353663244,2024-03-10T17:50:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.006875574588776,2024-03-10T18:00:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.09810053507487,2024-03-10T18:10:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.883333873748779,2024-03-10T18:20:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,15.038900661468507,2024-03-10T18:30:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,15.274134159088135,2024-03-10T18:40:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,15.444200801849366,2024-03-10T18:50:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,15.418567434946697,2024-03-10T19:00:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,15.157734044392903,2024-03-10T19:10:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.52115674316883,2024-03-10T19:20:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.35992360726381,2024-03-10T19:30:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.396317195892333,2024-03-10T19:40:00Z
,2,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,Polestar Buz,11.120879830985233,2024-03-10T19:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.7034203052520756,2024-03-04T21:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.719571726662772,2024-03-04T21:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.734545736601858,2024-03-04T21:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.7082502501351495,2024-03-04T21:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.726375311613083,2024-03-04T21:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.704533576965332,2024-03-04T21:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.728100268046061,2024-03-04T22:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.733633581797282,2024-03-04T22:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.72456693649292,2024-03-04T22:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.727966976165772,2024-03-04T22:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.742100302378336,2024-03-04T22:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.74166693687439,2024-03-04T22:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.746233606338501,2024-03-04T23:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.742755815717909,2024-03-04T23:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.741400265693665,2024-03-04T23:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.746083609263102,2024-03-04T23:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.7383457097140225,2024-03-04T23:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.723407657058151,2024-03-04T23:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.717000272538927,2024-03-05T00:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.718533563613891,2024-03-05T00:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.720366970698039,2024-03-05T00:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.7282336235046385,2024-03-05T00:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.716433604558309,2024-03-05T00:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.7196002960205075,2024-03-05T00:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.733433564503987,2024-03-05T01:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.701666955594663,2024-03-05T04:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.689066934585571,2024-03-05T04:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.678840236663818,2024-03-05T04:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.6694817543029785,2024-03-05T04:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.698769459357629,2024-03-05T04:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.696077218422523,2024-03-05T05:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.700920238494873,2024-03-05T05:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.6760478019714355,2024-03-05T05:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.681229452292125,2024-03-05T05:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.696683605511983,2024-03-05T05:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.69091694355011,2024-03-05T05:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.69376217751276,2024-03-05T06:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.678032521278627,2024-03-05T06:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.6983217511858255,2024-03-05T06:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.682658182947259,2024-03-05T06:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,3.010406404733658,2024-03-05T06:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T06:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.708703994750977,2024-03-05T17:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.71171897649765,2024-03-05T17:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.671400356292724,2024-03-05T17:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.663000281651815,2024-03-05T17:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.678500239054362,2024-03-05T17:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.681866963704427,2024-03-05T18:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.678133583068847,2024-03-05T18:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.681533606847127,2024-03-05T18:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.6995137704385295,2024-03-05T18:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.665133635203044,2024-03-05T18:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.663450256983439,2024-03-05T18:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.683265569258709,2024-03-05T19:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.679500237755153,2024-03-05T19:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.686111397213406,2024-03-05T19:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.685778035057916,2024-03-05T19:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.680631825798436,2024-03-05T19:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.701400264104207,2024-03-05T19:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.685233608881632,2024-03-05T20:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.68140027999878,2024-03-05T20:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,5.021692569439228,2024-03-05T20:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T20:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T20:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T20:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:10:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:20:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:30:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:40:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:50:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:00:00Z
,3,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l2,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:10:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,2.878500074148178,2024-03-10T17:10:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,10.646033240146325,2024-03-10T17:20:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.111083809534708,2024-03-10T17:30:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.28533385781681,2024-03-10T17:40:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.42567494858143,2024-03-10T17:50:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.352000534534454,2024-03-10T18:00:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.538400586446127,2024-03-10T18:10:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,12.517900689442952,2024-03-10T18:20:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,15.523467350006104,2024-03-10T18:30:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,15.386367416381836,2024-03-10T18:40:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,14.998467286427816,2024-03-10T18:50:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,15.102367369333903,2024-03-10T19:00:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,15.165634059906006,2024-03-10T19:10:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.433813020586967,2024-03-10T19:20:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.288436400584686,2024-03-10T19:30:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,11.337617286046346,2024-03-10T19:40:00Z
,4,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,Polestar Buz,10.934914375173635,2024-03-10T19:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7723602867126464,2024-03-04T21:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.776500304539998,2024-03-04T21:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.761636618411902,2024-03-04T21:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.777571712221418,2024-03-04T21:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.766093999147415,2024-03-04T21:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.789400323232015,2024-03-04T21:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.780566914876302,2024-03-04T22:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.774033546447754,2024-03-04T22:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7703335603078205,2024-03-04T22:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.774633630116781,2024-03-04T22:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.78326694170634,2024-03-04T22:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.769233624140422,2024-03-04T22:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.775566975275676,2024-03-04T23:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7817780706617565,2024-03-04T23:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.780900263786316,2024-03-04T23:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7803502957026165,2024-03-04T23:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.786327544125643,2024-03-04T23:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.772778087192112,2024-03-04T23:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.775148409384268,2024-03-05T00:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.789733584721883,2024-03-05T00:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.773466984430949,2024-03-05T00:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.763533608118693,2024-03-05T00:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.772133620580037,2024-03-05T00:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.774466959635417,2024-03-05T00:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.779133605957031,2024-03-05T01:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.762566947937012,2024-03-05T01:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.770100243886312,2024-03-05T01:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.772357378687177,2024-03-05T01:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.775583616892496,2024-03-05T01:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.752483622233073,2024-03-05T01:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.762068037259376,2024-03-05T02:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.774600240919325,2024-03-05T02:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.779628835405622,2024-03-05T02:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.77613361676534,2024-03-05T02:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7706003030141195,2024-03-05T02:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.752066946029663,2024-03-05T02:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.762433608373006,2024-03-05T03:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.749106670947785,2024-03-05T03:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.768883625666301,2024-03-05T03:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.73033360640208,2024-03-05T03:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.749318480491638,2024-03-05T03:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.739423330013569,2024-03-05T03:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.745857443128314,2024-03-05T04:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7487039742646395,2024-03-05T04:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.749266942342122,2024-03-05T04:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.756920280456543,2024-03-05T04:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7332965709545,2024-03-05T04:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7115771770477295,2024-03-05T04:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.721154121252207,2024-03-05T05:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.723360271453857,2024-03-05T05:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.727095513116746,2024-03-05T05:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.726208617289861,2024-03-05T05:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.715116953849792,2024-03-05T05:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.724333588282267,2024-03-05T05:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.739428872153873,2024-03-05T06:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.75258090419154,2024-03-05T06:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.731750283922468,2024-03-05T06:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.719263428135922,2024-03-05T06:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,3.0063439160585403,2024-03-05T06:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T06:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T07:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7231484519110785,2024-03-05T17:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7296252399683,2024-03-05T17:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7503336270650225,2024-03-05T17:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.741233571370443,2024-03-05T17:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.627900218963623,2024-03-05T17:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.6671669483184814,2024-03-05T18:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.738200314839681,2024-03-05T18:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7198668956756595,2024-03-05T18:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.73983807177157,2024-03-05T18:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.744483598073324,2024-03-05T18:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.729450265566508,2024-03-05T18:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.728224773796237,2024-03-05T19:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.696674181067425,2024-03-05T19:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.752200264400906,2024-03-05T19:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.750022485521105,2024-03-05T19:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.725842337859304,2024-03-05T19:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.758700275421143,2024-03-05T19:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.741033633550008,2024-03-05T20:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.7313603591918945,2024-03-05T20:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,5.097038672520564,2024-03-05T20:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T20:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T20:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T20:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T21:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T22:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T23:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T23:10:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T23:20:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T23:30:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T23:40:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-05T23:50:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-06T00:00:00Z
,5,2024-03-04T15:22:52.460254272Z,2024-03-11T15:22:52.460254272Z,l3,chargeCurrents,Voortuin,i4 Mario,0,2024-03-06T00:10:00Z

homemonitor · March 11, 2024, 3:35pm

The field Vehicle changes but should be “not taken into account” when getting the values, I just want to visualise the meters, the last values.

homemonitor · March 19, 2024, 12:40pm

Hello @yosiasz , was the list of measurements helpful? As I see it the query should only select the values and not select the vehicle. Is there anyway how I can achieve that?

homemonitor · April 15, 2024, 2:35pm

Hello @yosiasz , did you have some time or energy to guide me to a solution for this?

homemonitor · April 29, 2024, 1:33pm

@yosiasz i have been able to “group”/“consolidate” all the cars in one big line but if the vehicle is “null” it shows up as a seperate measurement. Do you have any idea to “combine” these 2?

from(bucket: “EVCC”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “chargePower”)
|> filter(fn: (r) => r[“_field”] == “value”)
|> filter(fn: (r) => r[“loadpoint”] == “Voortuin”)
|> map(fn: (r) => ({ r with vehicle: “car” }))
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: “mean”)

→