9 Replies Latest reply on Jan 26, 2017 4:30 PM by philmodjunk

    Counting date occurances

    afwalton

      I am fairly new to FileMaker and I am having difficulty creating a summary or report of dates.

       

      For example; I have a table with the following records:

       

      OrderStepEstimated Date for Completion
      Status
      5000101/12/20171
      5000201/13/20171
      5000301/13/20171
      5001101/12/20173
      5001201/12/20173
      5001301/12/20171


      The orders have multiple steps for completion and each step should be completed on a certain day. Each step has a status of "1 - Not Started" "2 - Currently being done" and "3 - Step Complete"

       

      I want to create a summary or graph to list the dates that have Uncompleted steps and give me a total of how many steps need to be completed on that date.
      "01/12/2017 has 2 tasks that need completed.
      01/13/2017 has 2 tasks that need to be completed."

       

      I have read some posts about SelfJoin relationships, but they have not provided me with what I am looking for or I am missing a piece of logic that would solve the issue.