How do I group twice?

[ansryss]

First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.

What I’m trying to do

Ive read the community posts before resulting to this. I dont have coding knowledge. I just want to group this into two column and i dont know much about dataviewjs.

Is it possible to have sub-area and outcome column separately?

Things I have tried

This is the best i can do.

TABLE rows.file.link
FROM ""
WHERE contains(main-area, "Professional development") AND outcome
GROUP by flat(list(join("**" + sub-area + "**"), outcome)) as "sub-area & outcome"

[holroy]

Do you mean something like the following untested query?

```dataview
TABLE WITHOUT ID 
  "**" + key[0] + "**" as "Sub-area",
  key[1] as outcome,
  rows.file.link as Notes
WHERE contains(main-area, "Professional development") AND outcome
GROUP BY list( sub-area, outcome )
```

[ansryss]

@holroy

```dataview
TABLE WITHOUT ID 
  "**" + key[0] + "**" as "Sub-area",
  key[1] as outcome,
  rows.file.link as Notes
WHERE contains(main-area, "Professional development") AND outcome
GROUP BY list( sub-area, outcome )

It works!

Although sub-area is not grouped together as I wish, its enough to see things better and im happy. Thanks for your help!

[holroy]

Yeah, rowspan on the sub-area would be nice, but it isn’t a thing currently. I wish it was though…