What I’m trying to do
i found this blood pressure tracker here but i don’t know how to code and i wanted to know if it was possible to get it to only check my weekly readings even if id multiple during the day
TABLE WITHOUT ID Days, map(rows.sysdias, (s) => split(s, "/")[2]) AS time, map(rows.sysdias, (s) => split(s, "/")[0]) AS systolic, map(rows.sysdias, (s) => split(s, "/")[1]) AS diastolic, map(rows.sysdias, (s) =>choice(number(split(s, "/")[0]) < 120 and number(split(s, "/")[1]) < 80, "🟢 normal", choice((number(split(s, "/")[0]) < 120 and number(split(s, "/")[1]) >= 80 and number(split(s, "/")[1]) <= 89) or (number(split(s, "/")[0]) >= 120 and number(split(s, "/")[1]) < 80) or (number(split(s, "/")[0]) >= 120 and number(split(s, "/")[0]) <= 139 and number(split(s, "/")[1]) >= 80 and number(split(s, "/")[1]) <= 89), "🟡 elevated", choice((number(split(s, "/")[0]) <= 139 and number(split(s, "/")[1]) >= 90) or (number(split(s, "/")[0]) >= 140 and number(split(s, "/")[1]) <= 89) or (number(split(s, "/")[0]) >= 140 and number(split(s, "/")[1]) >= 90), "🔴 high", "error")))) AS level WHERE sysdias WHERE file.day.weekyear = number(split(this.file.name, "W")[1]) FLATTEN sysdias GROUP BY file.link AS Days SORT file.name ASC
sorry to bother and thanks in advance