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
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.

Outcomes