AnsweredAssumed Answered

Counting date occurances

Question asked by afwalton on Jan 23, 2017
Latest reply on Jan 26, 2017 by philmodjunk

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.