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:
|Order||Step||Estimated Date for Completion||Status|
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.