I am a newbie to Tableau. Could somebody help me with this?
I have the below requirement.
I need to find out the mileage of the tire. See below sample data.
MILEAGE_ONMILEAGE_OFFTIRE_TREADCategory1440001800003A1440001800003A35000620003B1000450002C3400550006D
Mileage_on is the mileage of the vehicle when the tire was put on.
Mileage_off is the mileage of the vehicle when the tire was pulled off.
Tire_thread is is the tire tread amount remaining when the tire is removed. (X/32"), inches
I need to know the mileage of the tire by category. However, as you can see from the data, not all tires were worn all the way down. Therefore, what we do is linearly extrapolate down to the wear bar of the tire ( 2/32") so it's an apple to apple comparison.
For example:
New Tire - 10/32" - 0 miles on the tire
Used Tire - 6/32" - Has been run for 30,000 miles when returned
Legally Worn Tire - 2/32" - ??? Calculate this value to be 60,000 miles using linear extrapolation. This 60,000-mile number is the one we report for this tire.
Is this requirement possible to implement in Tableau? If so, please let me know how to do this.
Are these the values you are looking for?
If so, see attached workbook. If not, please provide the values you want, and the formula you used to get them.
