Weekly summary field
Hello, I have one table called "Tests" which has one record for each Test and some results. One numeric result field is called "Efficiency." There is a field "Type" which is multiple-choice and can b...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt sounds to me that all you need to do is look up this field Part's "Ref Date"
down to testrs.
Then have a checkbox formula field for
FirstDayOfWeek([test date]) = FirstDayOfWeek([Part's Ref Date])
and limit the average in the summary field to where that checkbox is true.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
down to testrs.
Then have a checkbox formula field for
FirstDayOfWeek([test date]) = FirstDayOfWeek([Part's Ref Date])
and limit the average in the summary field to where that checkbox is true.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thanks for your suggestion. I started implementing this but I don't think it will work in my situation. I want every Part to look at ALL Test records to get the average "Efficiency" for all Tests which have FirstDayOfWeek([Test Date]) = FirstDayOfWeek([Part Ref Date]).
So if I have the relationship one Part < many Tests, your process only works for the Part to summarize its related Tests, and not all of them. Perhaps I need some intermediate step to facilitate a many-to-many relationship and build up the summary fields, but I can't figure out how to do it.
To break the problem down to an earlier stage, what I really need is to automatically create a weekly summary field or record that summarizes the average Efficiency of all Tests from the previous week. Then I can hopefully relate this table of weekly summaries to my Parts table and pull the reference average Efficiency related to the week from which the Part was built. I'm not sure how to go about these steps though, or if they're possible with native QB capability.
------------------------------
Graeme
------------------------------
So if I have the relationship one Part < many Tests, your process only works for the Part to summarize its related Tests, and not all of them. Perhaps I need some intermediate step to facilitate a many-to-many relationship and build up the summary fields, but I can't figure out how to do it.
To break the problem down to an earlier stage, what I really need is to automatically create a weekly summary field or record that summarizes the average Efficiency of all Tests from the previous week. Then I can hopefully relate this table of weekly summaries to my Parts table and pull the reference average Efficiency related to the week from which the Part was built. I'm not sure how to go about these steps though, or if they're possible with native QB capability.
------------------------------
Graeme
------------------------------
- MarkShnier__YouUnfortunately I think that this is too complicated to solve on the forum. I am not clear what you really need. I think this will take some one on one Zoom time to sort out.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Mark,
No problem. I appreciate the help. I'm sure I'll figure out some workaround for this.
Thank you,
Graeme
------------------------------
Graeme
------------------------------