Dataview Query Not Returning Reult

Help
1

Hi All,

New to Obsidian, apologies for my ignorance. I am trying to create a Dataview Query to track Instagram Followers over time. I created a Daily Note Template with the Following Code:

---
date: 2025-04-16
followers: 2,744
goal: 5,000
---

These notes are stored in a Daily Journal folder

I then created a note, Instagram Follower Tracker, wirh the following Dataview Query:

```dataview
TABLE
  file.day as Date,
  followers as Followers,
  goal as Goal,
  round(followers / goal * 100) + "%" as Progress,
  "<progress value='" + followers + "' max='" + goal + "'></progress>" as "Progress Bar"
FROM "Daily Journal"
WHERE followers
SORT Date ASC
```

It creates a table but does not return any results.

ile0 Date Followers Goal Progress Progress Bar

Dataview: No results to show for table query.

I am not sure where to go next, what am I missing?

2

Is there a comma in your numbers because of your regional settings? Or is there a chance your properties are text instead of a number? (Mine would show up as followers: 2744)

I did a test and if I get rid of the round(followers / goal * 100) + "%" as Progress, line, then it works.

If I keep that line, then it seems to have an error that round() is giving an error saying that it is trying to divide by a string. But I definitely set my test properties to numbers:

Dataview: Every row during final data extraction failed with an error; first 3:

            - No implementation found for 'number / string'

I’m not sure why.

3

thanks for the reply, should not be commas, I inserted by accident. I removed them from my entry and the code, still doesn’t work and I am not getting your error either. Do I need to change something else?

4

It shouldn’t be possible to add commas to numbers by accident. Make sure to change the property type to a number instead of a text property.

screenshot_2025-04-16_09-20-41
screenshot_2025-04-16_09-20-41546Ă—220 40.7 KB

As for other problems, sorry I don’t know.

Is your folder actually called “Daily Journal”?

One thing I would do is keep removing lines until you get SOMETHING. Like how I removed the “round” line. And then slowly add each line back. Try to isolate the problems one-by-one.

I’ll add the “dataview” tag to your post, and hopefully one of the Dataview experts will be able to help more.

5

You helped me fix it. First, yes, I figured out how to change the property types to numbers. After that, I got the error you did. I then removed that line, and it worked!!

Thank you, truly appreciated!

1 Like