3 Replies Latest reply on Aug 19, 2015 9:50 AM by Michael Dear

    Trying to replicate Excel Countif statements and having a hard time.

    Michael Dear

      Hi all,

       

      I'm having a hard time trying to replicate multiple Excel COUNTIF statements in Tableau.

      I need to track a trend of open work orders week on week and have an excel file to do this.This is made up of COUNTIF formulas that sum work orders open on a particular date. To go back in time and see how many work orders were open on a particular date the formula calculates work orders open on a particular date and closed greater than that same date plus work orders open on a particular date and not closed.


      I know this is possible in Tableau but at my level I can't figure out the calculation. The excel file explains my problem and formulas in more detail.


      Appreciate any suggestions that you guys have.