3 Replies Latest reply on Dec 30, 2014 2:59 PM by ben kwok

    how do i count the number of dates in a column if it is equal to a specific date?

    ben kwok

      I am working within Excel and have a table with a column with many dates. all i want to do is count the number of occurances that a specific date appears. this is trivial in excel. I could do something like: =COUNTIF(startrange:endrange,"1/1/12") and it would yield the value for me. when i do this same thing in tableau:

       

      count(

      if ([xyzMonth]) = date(1/1/2012)

      then [xyzMonth] end

      )

       

      it get no results. I've tried the reverse where I start with the IF statement and then count. my source data clearly has many dates equal to 1/1/2012. eventually i want to expand this to replacing the date with a parameter.