Dataview Sums and Average

Help
17

So now it seems like the sum() function to generate the Average generates the error.

I got another trick up my sleeves to detect the anomaly in your data set. Could you please try the following:

```dataviewjs
const result = await dv.query(`
TABLE minutes
FROM "Archive 🗃️/Journal 📅/Days"
WHERE MONTH = [[2023-Jan]]
WHERE minutes
`)

if ( result.successful ) {
   const noNumbers = dv.array(result.value.values)
    .where( v => typeof(v[1]) != "number")
    .map( v => [ v[0], v[1], typeof(v[1]) ] )

   dv.table(["File", "field", "type"], noNumbers)
} 
else
  dv.paragraph("~~~~\n" + result.error + "\n~~~~")
```

With a contrived test set of mine, I got the following output:

image
image746×239 15.2 KB

Where all my noNumbers were:

  • the first entry was a minutes:: "660", aka string
  • the second entry was multiple minutes:: definitions
  • the third had the value ==660==, aka highlighted
  • the fourth was a random link?!

What do you get running that query on your data set?

1 Like