Dataview Sums and Average

[Craig]

@paoloap

I’m also not familiar with the flatten operator

Here is a post that goes into detail about how the GROUP BY and FLATTEN operators work. I hope you find it helpful.

"Group by" Woes

There’s a lot going on here, and mastering it will require you to learn some of the ways in which Dataview works differently than a traditional database. In particular, it’s worth studying how GROUP BY and FLATTEN work. The docs provide some help, and there are some good posts on the forum that go into detail. For the following examples I used the same input data: [image] We can visualize this data with a simple table: ```dataview TABLE Name, Occupation, Born ``` [image] One complicati…