4 Replies Latest reply on Jan 7, 2012 8:52 PM by Richard Leeke

    Table Calculation Help Needed for a Newbie

      I am relatively new to Tableau and could use some help with a table calculation issue.

       

      Here is the scenario I am trying to solve:

      For each successive Monday, starting with an arbitrary date defined by a parameter, I'd like to count how many employees I have that have been employed less than 60 days.  To make such a calculation, I need to count every record for each Monday that is true for these criteria:

      Parameter - [startdate] >0 and <60

      [termdate] > Parameter

       

      So, for example, if my parameter was 12/5/2011, then I would want this count for 12/5, 12/12, 12/19, 12/26, etc.

       

      Is this achievable with a table calculation?

       

      Thanks for any help provided,

      Jason