If you did a Find for Active and a second find (Omit) for the last seven days
this would give you the answer you wish?
The find could be done at startup, or would it have to be uptodate as of right now?
If you can establish a relationship that connects the group of records you want to count, you can also use the count function to count the number of related records. This avoids the need for special scripting, but instead requires setting up some keys and relationships.
Example: If you have a field that auto enters the creation date called "DateCreated" then the date calculation
"Weekof" ; DateCreated - DayofWeek(DateCreated) + 1
Will return the Sunday date of that week for all records created on that week.
Now set up an unstored calculation: "ThisWeek"; Get ( currentdate ) - dayofweek ( get ( currentdate ) ) + 1 to produce a matching date for the current week.
Now create the relationship Yourtable :: ThisWeek > Yourtable 2 :: Weekof
Third calc field: Count ( Yourtable 2 :: DateCreated ) will return the total number of records created prior to this week.
This technique borrows a calc shared by Comment in another thread.
You can do variations of the above to count various other groups of records.
I get this, at least I think I do. By using a relationship via a copy of the table the number of records won't change if I do a find that reduces the number of records in primary table? Right?
It's not a "copy of a table" though it may look that way.
When you build relationships in Filemaker each "box" in the graph is really a "Table Occurrence" (TO). Each TO may point to any table you've defined in the file or any file to which you've established an external reference.
In my example the "copy" is really just a second TO pointing to the same table as your original table. This type of "self join" can be created on the graph simply by dragging from one field in the TO box to outside the borders and then back to a field inside the same box. Filemaker will pop up a dialog for an "Instance" of the current table where you can give this TO a name.
I'm clear on that even if I did not use the proper terminology. BUT...will it keep the count constant even if I've done a find that reduces the number of records to a subset of their totals?
As long as you have at least one record in your found set (so the relationship is valid), the totals will not be affected by the current number in the found set.