Dataview: display the sum of a table column

[jonathanchengjr77]

What I’m trying to do

I have a simple table, where one of the columns, labeled Score, is numeric.

The table code is here:

TABLE WITHOUT ID
file.link as Date,  
choice(Sleep, "✅", "❌") as 🛌,  
choice(Exercise, "✅", "❌") as 🏋‍♂,  
choice(Drawing, "✅", "❌") as 🎨,  
choice(Work, "✅", "❌") as 💻,
Sleep + Exercise + Drawing + Work as SCORE
FROM #dailies 
WHERE file.day <= date(now) AND file.day >= date(now) - dur(30days)  
SORT file.day ASC  

The table works fine.

What I want: a number, separate from the table, that shows the average SCORE of the table.

NOTE: I do not want this to be part of the table itself. I would love to simply have a paragraph element or something below and away from the table that displays just one number (the average SCORE).

Things I have tried

I’ve tried the solutions listed in the following links:

Dataview Table: Summing a column

What I’m trying to do So I want to create a simple data view table of my monthly subscriptions that sums up the price column for me. I’ve searched all over the forum and online, and it seems so simple of a task yet the threads have all been extremely confusing for a newbie like myself. My folder organization is the following: Folder called “Subscriptions” that contains two subfolders: a subfolder called “01_Index” with a note inside called “Index” a second subfolder called “02_List” followe…

Best Method to Display the Sum Total of a Dataview Column?

Things I have tried I’ve been messing around with the sum() function but everytime I try, I break the table I’ve created. What I’m trying to do I am attempted to track my spending in a rapid log format in my daily notes. In other words, I’m hoping to just type something along the lines of “Spending:: Starbucks - 10” into my daily notes rapid log, and then use Dataview to compile that information later. So, for example, a given day’s rapid log may look like this: 9:00am Spending:: Bought…

to no avail…

[holroy]

Given that your table actually shows the score you want to average, then the following table should produce the number you want:

```dataview
TABLE WITHOUT ID average(rows.score)
FROM #dailies 
FLATTEN Sleep + Exercise + Drawing + Work as score
WHERE file.day <= date(now) AND file.day >= date(now) - dur(30days)  
GROUP BY true
```

You could debug this by removing the GROUP BY true line, and just use TABLE WITHOUT ID score to verify that it’s showing the correct scores to average.

However this produces an entire table to present this one number, which is a bit excessive, so lets add some dataviewjs around this query to lift out just that one result:

```dataviewjs

const result = await dv.query(`
  TABLE WITHOUT ID average(rows.score)
  FROM #dailies 
  FLATTEN Sleep + Exercise + Drawing + Work as score
  WHERE file.day <= date(now) AND file.day >= date(now) - dur(30days)  
  GROUP BY true
`)

if ( result.successful ) {
  const average = result.value.values[0][0]  // First rows, first column
  dv.paragraph("The average score is " + average)
} else
  dv.paragraph("~~~~\n" + result.error + "\n~~~~")

Hope this helps, and actually works as it is untested…