Teslamate: Drives: How to add odometer to dashboard?

[Eriktesla]

It would be great to have the possibility to view odo_start and odo_end in the drives dashboard:

This information is needed for the kilometer administration for the Dutch tax return ;-)

Any help to add odo_start and odo_end in the JSON panel is greatly appreciated.

[cwanja]

I think it used to be on the Drives dashboard, but to reduce the horizontal scrolling on the dashboard it was removed. I think it makes more sense on the Drive Details, under the smaller blocks in my opinion.

[Eriktesla]

The tax authorities impose the following requirements on the kilometer administration:

Drive date, drive ID, the start and end position of the odometer and the departure and arrival address.

The only items what I miss in the Drives dashboard is odometer start and odometer end.

If those items are available then it is a peace of cake to export all car trips (each trip is a row) to csv format.

[wooter]

The fields start_km and end_km are available in the table drives.

I'd have to look into the source to see how to integrate a new query and JSON in the necessary Drives dashboard, but basically you need to

• add "start_km, end_km," in both select queries.
• add 2 Column styles, one for start_km and the other for end_km

[roadrash2108]

I'm on it. Are above columns all you need?

Then I would suggest to build a new dashboard soley for the purpose of "Tax reporting" - what do you think?

[wooter]

Yeah, I made it myself already; copying the Drives dashboard into a separate dashboard, and modifying the columns.

I can do a push request, but it's already a crowded table.

[roadrash2108]

This would be my proposal for the table:

[Eriktesla]

Wow I am impressed! That is exact the information what is needed.
Maybe it is possible to add the column with the end date/time of the ride and a column with the duration of the ride.
That makes it complete.

[roadrash2108]

New version:

Does that fit, @Eriktesla ?

[roadrash2108]

@adriankumpf I'm sorry for my lack of knowledge, but can you give me some hints how to deliver this? (just create a new file in the repo with the JSON-model that I copy/paste out of my Grafana? If yes, I would suggest to deliver such "special reports" in a separate folder - simply create it or does it have to be created via Grafana?) Many thanks for guidance!

[Eriktesla]

@roadrash2108 , super, thanks a lot!

[cwanja]

Will this end up showing up for everyone as "Dutch tax" dashboard if using the Docker image?

[adriankumpf]

It'll show up in a separate folder:

[roadrash2108]

@Eriktesla can you please clarify if it is required to have the full address for start/end or is it suitable to have the name of the geofence/location in the report? many thanks!

[cwanja]

@Eriktesla can you please clarify if it is required to have the full address for start/end or is it suitable to have the name of the geofence/location in the report? many thanks!

The geofence _should_ work. It is just a wrapper around the physical address. Now for the tax authorities purposes, maybe they need the address as opposed to ‘Grandma’s house’. Maybe there is a way the dashboard can ignore geofences.

[Eriktesla]

@Eriktesla can you please clarify if it is required to have the full address for start/end or is it suitable to have the name of the geofence/location in the report? many thanks!

The full address for start/end is needed. Geofence addresses like home, work or mother's house are unfortunately not allowed be the Tax authority.