Notion Answers

Get help from other Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Weekly progress calculation ?

I have this Notion Habit tracker which contain day progress in percentage! similarly i'm looking for weekly progress by number.
the code for day progress is below

round(100 * (toNumber(replace(prop("Habit 1"), "true", "1")) + toNumber(replace(prop("Habit 2"), "true", "1")) + toNumber(replace(prop("Habit 3"), "true", "1")) + toNumber(replace(prop("Habit 4"), "true", "1")) + toNumber(replace(prop("habit 5"), "true", "1"))) / 5) / 100

Above code will give us the percentage divided by total habits(5)
my ideal output is when i completed habit 1 5times in a week the weekly progress should show habit1 : 5
any help would be appreciated thank in advance

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect