Help with FLATTEN (DATOVIEW)

[rascally_rabbit]

Hello everybody!

I need help with FLATTEN or GROUP BY, I can’t figure out how it should work.
I am trying to create a table with list of projects that has the current person in charge. The result is a table with many projects with the same names.

I want to combine all the same project names.

Can someone help me?

My code

```dataview
	table without id file.frontmatter.project as project
	from "/" and !"-=meta=-/templates"
	where file.frontmatter.type = "task"
	where file.frontmatter.person = this.file.name
	flatten file.frontmatter.project
	sort file.ctime desc

[henryfaber]

I had a similar question, albeit with a calculation involved, that a forum member was kind enough to help me with. Perhaps it could help?

Using DQL: Grouping results by calculation and date

Hi there! I’ve been trying to figure this out for a while and am hoping to not get into javascript to achieve what I’m trying to do. I’m hoping the community can help. What I’m trying to do I have notes from various activities that contain the duration of the activity, the classification of the activity (value flow), and the date of the activity. I’m trying to display the combined duration for activities, broken out their classification, grouped by the year and month. This is how far I can get…