Progress Bar - Coda (OKR)

[Ashley_Shuler]

I’m setting up my OKRs inside of Coda, I’m using the Progress Bar.

Now everything is 0 to 100.

If I have a key result such as Write 12 blog posts, can I configure the Maximum to be 12 for that Key Result or no?

[gose]

Hey!

You can calculate percentage using a formula
*.count()/12 * 100

thisRow.key.Filter(Status=Done).Count()/kpi*100

[Paul_Danyliuk]

You don’t have to set the maximum to a static value of 100 and normalize anything to those 100 — you can make it a formula to get your count differently for each row, e.g.

[Ashley_Shuler]

@Paul_Danyliuk, Am I doing this right?

I want to add the max to be 25 ?

[Paul_Danyliuk]

No — the “calculate” formula is to get the value. The value is your ....Count() of whatever you need to show (i.e. the formula that would return your actual progress: 1 if 1/24 tasks done, 10 if 10/24 done, 24 if all done etc). To set up the maximum value for the progress bar, you do that in Settings → Max Value.

I mean, many people overlook the fact that it doesn’t have to be a fixed number (i.e. by default it’s 100) but can be a formula that calculates to a different number based on the context of the row it’s in (i.e. rows are Key Results, and for each KR there’s a list of Objectives, and hence the formula for the Maximum Value setting will be something like thisRow.Objectives.Count())