This is how my measurement looks like, vehicle is a tag. odo (odometer) and speed are fields.
I created a variable “vehicle”, which queries my tag for selection so I can switch between vehicles on the dashboard, now when I select the “All” option, I want to be able to sum() just the max values of my tags to get the total mileage of all my vehicles. I am using influxdb as datasource.
Just a background, the max odo value of a vehicle is the total mileage of a single vehicle.