6 Replies Latest reply on Oct 18, 2018 7:48 AM by tadd.wagner

    Creating a baseline

    Grace Herron



      I am new to tableau and struggling with calculations.


      I need to create a baseline. Our baseline is the average cost per stop in 2017. This baseline is not rolling and should not change based on current date.


      My formula is below: The problem with this is the formula is taking the total route expenses for 2017 / the total stops for 2017. Instead,  I need it to sum the individual cost per stop for each month in 2017 and then divide by 12 to tell me the average.


      If ATTR([Months in Prior Year Pt 1] = TRUE) then [USHC Route Expense Per Stop w/o Fuel charge] else 0 END


      Any help would be greatly appreciated!