Blood pressure formula

Help
4

Before your last post I made this test (using Dataview), using different categories for test purposes.

## Categories
Normal: S < 120 and D < 80
Elevated: 120 ≤ S ≤ 139 or 80 ≤ D ≤ 89
High: S ≥ 140 or D ≥ 90


## Blood pressure - 2022-W01

```dataview
TABLE systolic, diastolic, choice(systolic < 120 and diastolic < 80, "🟢 normal", choice((systolic < 120 and diastolic >= 80 and diastolic <= 89) or (systolic >= 120 and diastolic < 80) or (systolic >= 120 and systolic <= 139 and diastolic >= 80 and diastolic <= 89), "🟡 elevated", choice((systolic <= 139 and diastolic >= 90) or (systolic >= 140 and diastolic <= 89) or (systolic >= 140 and diastolic >= 90), "🔴 high", "error"))) AS level
WHERE systolic
WHERE file.day.weekyear = number(split(this.file.name, "W")[1]) 
SORT file.name ASC
```

image
image1436×510 76.5 KB

In this example the logic was:

  1. In daily notes (with title in format “YYYY-MM-DD”) added two fields:
    systolic:: 132
    diastolic:: 86
  2. The query was created in weekly notes with the title in format “YYYY-[W]ww”, i.e., year and week number (example: 2022-W01)
  3. I only added one measurement per day. To multiple measurements per day this approach doesn’t work.

But after read your post, I’m not sure if this is the best approach for your intents.

1 Like