Red Gregory

View Original

Notion Showcase: How I Manipulate My Pedometer Data With Formulas

The Main View (All Basic Properties)

Click to Expand

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

Click to Expand

% 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")

Year View: 2020 Success Rate

Click to Expand

View Example