Hi @adarsh
When you use the GROUP BY
functionality, everything is returned in a rows
array, so your list is only showing the group indicator (1 as it appears all your notes have been created this month).
What you want to do now is to play around and see what data is in the grouping. Like I say that data exists in an array called rows
.
If you change your dataview query to the following, you should see all your data nestled inside:
```dataview
LIST
rows
FROM
#work_journal and -#hub
GROUP by
file.ctime.month as Month
```
This will return a lot of data so you will need to dig down to find what you want.
Based on your screen shot from the non-grouped query, we can return the link to the note as follows:
```dataview
LIST
rows.file.link
FROM
"Personal/Journal/Daily"
SORT
file.ctime desc
GROUP by
file.ctime.month as Month
```
This will return something like the following:
There might be a way to convert the month number that file.ctime.month
returns to make it prettier and more readable, but I’ve just started working with dataview over the past couple of weeks and have not looked into that. I’m also not sure if you can group multiple times like you would like for year and month. Well, you can group multiple times, but again I’m not skilled enough in the plugin to get it to return meaningful data from the multiple groupings.
I’ve tried multiple groupings like the following:
```dataview
LIST
rows.rows.file.name
FROM
"Personal/Journal/Daily"
SORT
file.ctime desc
GROUP BY
date(file.name).year as Year
GROUP BY
date(rows.file.name).month as Month
```
And the result is not what I would expect
Note that I don’t see a year value, but based on the groupings we can see that they are indeed grouped by year. I don’t know if this is a shortcoming of the plugin or just my not understanding the plugin at a deep enough level to make this work. If you figure it out, I would love to hear how you did it.
Hopefully this gets you a little bit further down your path to getting what you’re looking for.