Notion Showcase: How I Manipulate My Pedometer Data With Formulas
The Main View (All Basic Properties)
Daily-Goal:
This property returns a line of green checkmarks if # steps is greater than 10,000.
(prop("steps") > 10000) ? "✅✅✅✅✅✅" : ""
Avg. Hours/Day:
This property grabs the property directly from my pacer app export labeled activeTimeInSeconds and converts it into hours. I then round the calculation to clean up the number. More about rounding numbers in Notion here.
round(100 * prop("activeTimeInSeconds") / 60 / 60) / 100
Month View: Stats and Averages
% of Month that goal is achieved:
This property returns what percent of the month reached my 10,000 steps/day goal. I divide # of Days Goal Achieved by 31 (or roughly one month) and round the result. More about rounding numbers here.
round(100 * toNumber(prop("# of Days Goal Achieved")) / 31) / 100
In Progress?:
Here, a checkbox returns whether or not an entry is in the current month. For example, if this month (“now()”) is equivalent to the title of the page, a checked box will appear. In this case, my page is labeled “April 2020,” so I use the slice function to remove “2020” from the query.
formatDate(now(), "MMMM") == slice(prop("date"), 0, 5) or formatDate(now(), "YYYY") == prop("date")