How can I sum up multiple columns in a Dataviewjs query?

[holroy]

I’m running out of daylight, and got too much to do before going to bed, but check out the last query in the answer below. There I do sum up multiple columns and add them as a separate row under the other columns.

Maybe it’ll help you on your way?

Ad-hoc tracking in Dataview of games won

Hi there @anon63144152, here are some queries for you to ponder over, and maybe spend even more hours on studying! ## Base query ```dataview TABLE P1, P2 WHERE file.folder = this.file.folder AND file != this.file ``` ## Grouped by file ```dataview TABLE rows.P1, flat(rows.P1), sum(flat(rows.P1)), rows.P2, flat(rows.P2), sum(flat(rows.P2)) WHERE file.folder = this.file.folder WHERE P1 OR P2 GROUP BY file.name as GamesPlayed ``` ## Every game with game count(?) ```dataview TABLE …