Help

How to count Posts by Company in last seven days?

Solved
Jump to Solution
454 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_Andrews
6 - Interface Innovator
6 - Interface Innovator

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
JonathanBowen
13 - Mars
13 - Mars

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
JonathanBowen
13 - Mars
13 - Mars

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!