5 Replies Latest reply on Dec 3, 2014 8:01 PM by Chris McClellan

    Calculations & possible if statements.

    Jessica Hunter

      Hi,

       

      A bit of background: The data the I have in tableau is a calculation maintenance dates based on KM based assets. The maintenance requirements changes at varying service intervals, for example, minor exam 150k, exam 450k, major 900k. Obviously these exams overlap and when they do the greater exam is preformed.

       

      My question is, if the asset is showing both a 450k exam due and a 900k exam due on the same date (or say within 1 month or 2 of each other), how do  a preform a calculation to say that if there is 2 exams due at once, to preform the exam with the highest service interval?

       

      Appreciate your help.

       

      Jess

       

      *Sample data and workbook attached