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

    Counting date occurances


      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

      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.