Hi - I would like to have a simple chart to show how many miles I’ve driven in my car vs how many miles in my ontract hire allowance. i.e 10,000 mile allowance over 4 years = 40,000 miles in total. If I was 2 years into my contract I want the chart to show 20,000 miles as my target mileage, but also show my actual mileage so I can see if i’m over or under the target.
I have a sensor entity which gives my actual mileage but I dont know how to get the target number into a chart. I’m guessing I need to divide the 40,000 miles by 1460 days (4 years) = 27.39miles per day then somehow increment this number each day from a set start date ?
Any help would be appreciated - especially if it is a dummies guide . . .
thanks in advance.