Skip to main content
Solved

How to count Posts by Company in last seven days?

  • May 25, 2021
  • 2 replies
  • 40 views

Forum|alt.badge.img+10

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.

Best answer by JonathanBowen

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

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)

2 replies

JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • Answer
  • May 25, 2021

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

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)


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • May 25, 2021

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

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!