Is nested grouping possible?

[awlobo]

Hi! I'm using the example in the README to sort my video games data

```dataviewjs
let groups = dv.pages("#videogame")
    .groupBy(p => p.Status)

for (let group of groups) {
    dv.header(3, group.key);
    dv.table(["Name", "Platform", "Started"],
        group.rows
            .sort(k => k.started, 'asc')
            .map(k => [k.file.link, k.Platform, k.started]))
}

This results in something like:

- Video games
  - In Progress
     - Game 1
     - Game 2
  - Backlog
     - Game 3
     - Game 4
  - Wishlist
     - Game 5
     - Game 6

But I was wondering if it would be feasible to add another grouping layer, for instance, by platform:

- Video games
  - In Progress
     - PC
       - Game 1
       - Game 2
    - Nintendo Switch
       - Game 3
       - Game 4
  - Backlog
     - PC
       - Game 5
       - Game 6
    - Nintendo Switch
       - Game ...
       - Game ...
  - Wishlist
     - PC
       - Game ...
       - Game ...
    - Nintendo Switch
       - Game ...
       - Game ...

Is this possible or do I have to make a query per State?

[I-Pch]

I don't have any answer 😔 ... but I would also be very interested in knowing if it's feasible 😊

[awlobo]

I don't have any answer 😔 ... but I would also be very interested in knowing if it's feasible 😊

Sorry, I forgot to update on this. I figured it out:

let groups = dv.pages("#videogame").groupBy(p => p.status)

for (let group of groups) {
    var platforms = group.rows.groupBy(p => p.platform);
    dv.header(1, group.key);
    for (let platform of platforms) {
        dv.header(5, platform .key);
        dv.table(["Name", "Started"],
            platform .rows
                .sort(k => k.file.name, 'desc')
                .map(k => [k.file.link, k.started])
       )
    }
}

[I-Pch]

I'm kind of nowhere (yet) when it comes to dataview (still exploring) but this looks exactly like the grouping I would need ... I just need help to get started 😊 ... So Thank you very much @awlobo 😁 !

[awlobo]

Anytime! Once you get the hang of it, it's a lot of fun 😊

[blacksmithgu]

Nested loops with group by is the easiest way, as another commenter mentioned:

let bigGroup = dv.pages().groupBy(p => p.thing);
for (let item of bigGroup) {
   let subGroup = item.rows.groupBy(p => p.thing2);
  for (let subitem of subGroup) {
     ....
  }
}