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.
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.
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.
```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
```