1 Reply Latest reply on Nov 2, 2018 2:19 PM by Cathy Bridges

Calculated Field By Month

Hello Tableau Enthusiasts,

Context

I’m working on a dashboard for tracking the mileage of a vehicle. Sort of a KPI chart for mileage. In this case, this vehicle must run 160,000 km on a fixed route of 576 km from Monday to Sunday, which means: 576 km * 7 days= 4032 km/week.  Nevertheless, when the vehicle presents mechanical problems, or other kind of issues the vehicle doesn’t run kilometers, which means the test gets delayed by 576 km per day or the correspondent mileage subtraction when an incomplete day (576 – 376=200km).

Challenge

The source data includes the page “Plan Mileage Data” that accumulates the daily planned mileage. And the “Dashboard Data” page that compares the mileage accumulated vs the plan accumulated.

<- Plan Mileage Data<-Dashboard Data

I want to make an easy calculated field to express the following:

I attach the workbook. Thanks a lot for your help.

• 1. Re: Calculated Field By Month

I'm not 100% sure I understand the issue, but I created the calculated field you described as

[Mileage Accumulated]/[Plan Accumulated]

Then I put that calculation in the view, right-clicked on it and selected "Quick Table Calculation" and selected "Running Total".

Is that what you're aiming for?