Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to count Posts by Company in last seven days?

Solved
Jump to Solution
190 2
cancel
Showing results for 
Search instead for 
Did you mean: 

There are two linked tables:

  • Posts (ie. an index of blog posts, with dates)
  • Companies (a list of companies who author blog posts)

Companies already has a Count field column to display the total Posts by given Company.

However, I’d like also to count the posts by Company within the last seven days.

One view of Posts is filtered to show records with dates within the last week.

But how do I utilise this or similar on the Companies table?

Thanks.

1 Solution

Accepted Solutions

Hi @Robert_Andrews - you can use the “conditional” setting on the count field:

Screenshot 2021-05-25 at 21.15.41

When you toggle this on you can set the conditions much like a filter on a view (but you’re not using an existing view here directly - just replicating its conditions within this count field)

See Solution in Thread

2 Replies 2

Hi @Robert_Andrews - you can use the “conditional” setting on the count field:

Screenshot 2021-05-25 at 21.15.41

When you toggle this on you can set the conditions much like a filter on a view (but you’re not using an existing view here directly - just replicating its conditions within this count field)

Ahh… perfect, @JonathanBowen. Diolch/thanks!