4 Replies Latest reply on Dec 27, 2013 11:26 AM by keren.abina-sotomayor

    How do I count dates only when there is a value attached to that date in another column?

    keren.abina-sotomayor

      Hi,

       

      I need to get a count of days when people have worked. I'm trying to get this by counting the number of "Time Card Date". However, everyone has a date in the "Time Card Date" column. I only want to cound those dates where the corresponding "total Hours" are greater than zero. I tried to do  a simple County(TimeCardDate), and then filter the rgaph by total hours, but that then includes everyone who has more than zero hours, regardless of whether the dates had hours "attached" to them. An example of what my data looks like is below. The calculation I need would show me that ClientID 1 worked 2 days, ClientID 2 worked 3 days, and so on.

       

      Thank you for your help!

       

      .

      ClientIDTimeCardDateTotalHours
      11/1/20130
      11/2/20130
      11/3/20135
      11/4/20130
      11/5/20135
      21/1/20135
      21/2/20130
      21/3/20135
      21/4/20135