How to see differences the totally Number of KM's for my CAR?

I need to see on my graph the totally number of KM which i have did between when the CAR is fully tank.

I am receiving the current measurements from influxDB and can see every time how much KM i did ride with the CAR. It registers automatically the last KM’s data when the car is stopped.

Just when i go to the tank station and the Car is fully tank the Line on this example goes higher. So the idea is so i can see de differences.

This is the current data which i can see on PANEL on RAW format:

SELECT last("value") FROM "default"."km" WHERE ("entity_id" = '320i_mileage') AND $timeFilter GROUP BY time(10s) fill(null)

With this Panel:

So what do i need to do to realize that?

Welcome @endrolar to the Grafana forum.

Could you please a portion of your data in csv or tabular format, for example:

total_km | fill_up_time
-------- | --------
435      | 2023-05-10T18:00:00Z
932      | 2023-05-18T11:00:00Z
1540     | 2023-05-25T14:00:00Z

What do you really mean? Do you mean send to you the source data? Where can i find this in Grafana? I can see it well on InfluxDB what you mean. Some LOGS in RAW format. Waiting your reply

I was asking if you could export the data from InfluxDB in .csv format so that others can work with it to help you find a solution.

The instructions to get the .csv data out of InfluxDB version depend on which version you are running. Which version of InfluxDB are you using? If it’s an earlier version that uses command line, it is probably something like:

influx -database 'myDatabase' -execute 'SELECT * from myMeasurement' -format csv > Influxdata.csv

i dont have access to the CLI command line because i am using home assistant addon of the InfluxDB.

I have tried via the GUI query the data but will not work for me with this example.

USE “homeassistant”; DELETE FROM “$” WHERE “entity_id” = ‘320i_remaining_range_fuel’ AND time > ‘2023-3-23T16:01:00Z’ and time < ‘2023-5-23T04:48:00Z’

USE “homeassistant”; DELETE FROM “$” WHERE “entity_id” = ‘320i_remaining_range_fuel’

ok, just i have found it. I have exported CSV file now using the script editor of InfluxDB. But i don’t have here any option to upload a file but see the screenshot.

Open the file in notepad, copy and paste here

There it is:

#group;FALSE;FALSE;TRUE;TRUE;FALSE;FALSE;TRUE;TRUE;TRUE;TRUE
#datatype;string;long;dateTime:RFC3339;dateTime:RFC3339;dateTime:RFC3339;double;string;string;string;string
#default;_result;;;;;;;;;
;result;table;_start;_stop;_time;_value;_field;_measurement;domain;entity_id
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T11:51:10.485338Z;228;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T14:01:37.256955Z;219;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T14:26:41.469638Z;210;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T14:56:46.087113Z;203;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T16:17:10.221094Z;199;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T17:22:24.122257Z;193;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T18:42:37.68833Z;185;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-19T22:08:16.22414Z;181;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-20T11:25:25.558421Z;181;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-20T11:35:26.928042Z;169;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-20T12:30:33.356579Z;159;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-20T15:51:04.628749Z;161;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T10:09:34.047684Z;161;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T10:49:42.585419Z;136;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T10:54:43.031742Z;135;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T11:04:45.097042Z;129;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T15:30:30.045925Z;118;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T19:16:23.95239Z;128;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T21:01:45.973523Z;121;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-21T22:07:01.254927Z;121;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-22T10:29:49.207474Z;104;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-22T11:04:57.730689Z;106;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-22T14:10:38.099584Z;100;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-22T15:25:51.22356Z;88;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T07:33:52.849474Z;68;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T07:48:55.392645Z;57;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T15:45:27.579649Z;63;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T16:50:41.284699Z;55;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T18:36:00.294829Z;308;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T18:51:01.07118Z;301;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T20:16:15.996845Z;281;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-23T21:56:34.967247Z;267;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T03:07:48.228324Z;267;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T06:23:46.576551Z;267;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T06:33:48.127254Z;260;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T06:48:51.353758Z;253;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T11:50:02.419848Z;249;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T12:20:09.598609Z;240;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T15:10:45.970744Z;239;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T15:30:52.630056Z;237;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-24T15:50:56.585366Z;232;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-25T06:43:46.939752Z;220;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-25T06:58:53.071347Z;211;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-25T07:14:00.077881Z;211;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-25T14:50:28.371852Z;210;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-25T15:10:33.469281Z;200;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-25T22:07:07.977814Z;200;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-26T06:29:07.219517Z;195;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-26T06:59:13.14896Z;182;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-26T07:34:27.291178Z;176;value;km;sensor;320i_remaining_range_fuel
;;4;2023-05-19T11:38:24.769164359Z;2023-05-26T11:38:24.769164359Z;2023-05-26T09:54:58.268942Z;173;value;km;sensor;320i_remaining_range_fuel

1 Like