Create a number card (chart) and count newly created items

[Chang (Chang-Ching)]

Hi, I want to create a Numbers widget and show how many new itmes created in the past 7 days.
I tried the Filters / Advance filters but didn’t find a proper way to do it.

[Megan345 (Megan)]

Hi! If you are using a Creation Log column, you can set up your Numbers widget as below to show the number of new items created in the past 7 days:

This method also works if you are using a Date column which you have automated to show the date an item was created:

1. In the widget settings, in the Numbers menu, select Count as the calculation type and make sure Items is ticked
2. Set the filter to show where Date Created or Creation Log is in the last 7 Days
3. Don’t forget to hit ‘Save Filters’!

[Chang (Chang-Ching)]

Hi @Megan345 , thanks a lot! I didn’t realize this column “Creation log.” It works beautifully. Thank you.

[sirah (Sirah E)]

Hi Chang,

Sirah here from Mindflows - An option you can go with is adding a date column onto your board and create an automation for when a new item is entered and set a condition on filter tab shown on my screenshot below:

Hope this helps!

[Chang (Chang-Ching)]

Hi Sirah, thank you for the suggestion!