Dataview Plugin: How to create a table that lists the number of new files created by date?

Hello,

I’m new to the forum, and I’ve just started learning the Dataview plug in. Thanks in advance for your patience with my request.

What I’m trying to do

I’d like to create a dataview table that lists a count of the total number of new files I’ve made per day in a specific folder. Something like this:

Date New Files Created

Jan 3 2
Jan 2 5
Jan 1 3

Things I have tried

I’ve been able to make a table that lists filenames and their creation date, but after a couple of hours of searching this and other relevant forums, I still can’t understand how to create summarized counts of the number of files by each date. I’ve also tried using the Tracker plug in, but I’m also struggling to get that to work.

See

https://forum.obsidian.md/search?context=category&context_id=19&q=List%20created%20files%20by%20date%20order%3Alatest&skip_context=true

Thank you for the suggestion. I conducted several searches like this before posting, but I haven’t been able to find a solution.

I’m not trying to list the created files by date. Instead, I’d like to count the created files by date and insert those count values in Dataview table rows by date.

Well, when you’ve got the list you can group the result and count how many rows you’ve got in each set.

Thank you. The algorithm you describe makes sense to me, but I’m struggling to understand the syntax that Dataview needs to execute it.

I’ve tried several syntaxes, but I generally get errors stating that Dataview expected a variable at GROUP BY, or I get a table that lacks the file names and has ‘-’ where the summed file counts should be.

Does this help at all?

```dataview
TABLE WITHOUT ID
dateformat(Date, "dd MMM yyyy") AS Date,
length(rows.file.name) as Created
FROM ""
WHERE file.cday
GROUP BY file.cday As Date
SORT Date ASC
```

1 Like

That works! Thanks so much for your help!

1 Like