Notion Habit Tracking W/ Analytics

Notion Habit Tracking W/ Analytics

Master Tag
Notetaking
Created
Apr 17, 2021 09:28 PM
Usage
Web Tags
Dashboard
Layout
Design
Formula
Cover

Donate

πŸ“±
Looks better in darkmode
β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…
⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️
Monthly Analytics
✏️
Daily Journal
Name
Month
Weekday
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Star Rating
Skip
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 2
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit 1
Habit 3
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Formulas

Star Rating (Habit Tracker)

if(prop("Progress") == 1, "⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️", slice("β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…", 0, 10 * round(100 * (unaryPlus(prop("Habit 1")) + unaryPlus(prop("Habit 2")) + unaryPlus(prop("Habit 3")) + unaryPlus(prop("Habit 4")) + unaryPlus(prop("Habit 5")) + unaryPlus(prop("Habit 6"))) / (6 - if(not empty(prop("Skip")), length(replaceAll(prop("Skip"), "[^,]", "")) + 1, toNumber("")))) / 100) + " " + format(prop("Progress") * 100) + "%")

Star Rating (Analytics)

if(prop("Habit Progress") == 1, "⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️⭐️", slice("β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…β˜…", 0, 10 * prop("Habit Progress")) + " " + format(round(100 * prop("Habit Progress")) / 100 * 100) + "%")

Progress

round(100 * (unaryPlus(prop("Habit 1")) + unaryPlus(prop("Habit 2")) + unaryPlus(prop("Habit 3")) + unaryPlus(prop("Habit 4")) + unaryPlus(prop("Habit 5")) + unaryPlus(prop("Habit 6"))) / (6 - if(not empty(prop("Skip")), length(replaceAll(prop("Skip"), "[^,]", "")) + 1, toNumber("")))) / 100

Month Progress

if(month(now()) > if(prop("Name") == "January", 0, if(prop("Name") == "February", 1, if(prop("Name") == "March", 2, if(prop("Name") == "April", 3, if(prop("Name") == "May", 4, if(prop("Name") == "June", 5, if(prop("Name") == "July", 6, if(prop("Name") == "August", 7, if(prop("Name") == "September", 8, if(prop("Name") == "October", 9, if(prop("Name") == "November", 10, if(prop("Name") == "December", 11, 999)))))))))))), "β–’β–’β–’β–’β–’β–’β–’β–’β–’β–’ 100%", if(prop("Name") == formatDate(now(), "MMMM"), if(year(now()) % 4 == 0 and month(now()) == 1, slice("β–’β–’β–’β–’β–’β–’β–’β–’β–’β–’", 0, 10 * toNumber(formatDate(now(), "D")) / 29) + slice("β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘", 10 * toNumber(formatDate(now(), "D")) / 29) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 29)) + "%", if(month(now()) == 0 or month(now()) == 2 or month(now()) == 4 or month(now()) == 6 or month(now()) == 7 or month(now()) == 9 or month(now()) == 11, slice("β–’β–’β–’β–’β–’β–’β–’β–’β–’β–’", 0, 10 * toNumber(formatDate(now(), "D")) / 31) + slice("β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘", 10 * toNumber(formatDate(now(), "D")) / 31) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 31)) + "%", if(month(now()) == 1, slice("β–’β–’β–’β–’β–’β–’β–’β–’β–’β–’", 0, 10 * toNumber(formatDate(now(), "D")) / 28) + slice("β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘", 10 * toNumber(formatDate(now(), "D")) / 28) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 28)) + "%", if(month(now()) == 1 or month(now()) == 3 or month(now()) == 5 or month(now()) == 8 or month(now()) == 10, slice("β–’β–’β–’β–’β–’β–’β–’β–’β–’β–’", 0, 10 * toNumber(formatDate(now(), "D")) / 30) + slice("β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘", 10 * toNumber(formatDate(now(), "D")) / 30) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 30)) + "%", "")))), "β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘β–‘ 0%"))
Β 
πŸ“†
Original Test Database
Β