Table “Companies” is a list of companies.
Table “Posts” lists blog posts, and has a Date field.
They are linked related between Companies’ “Posts” field and Posts’ “Company” field. ie. Posts relate to companies.
On the Companies table, I am able to successfully show a “Total Posts” count of the number of corresponding posts, by adding a Count field for the Posts table.
However, how can I add another column to Companies which only counts those Posts whose Date fields fall within the last seven days?
tl&dr - How do I count the number of linked records whose date falls within the last seven days?