I have a table called Features which lists down the feature, start date and end date. Now I want to create a column which shows me the progress of each feature in percentage bar. Can I also get the progress of the entire module based on the combination of features selected?
Hi @Medha_Ahuja ,
Welcome to the community!
There’s a column type just meant for that: the ‘Progress bar’.
Here’s a little demo for you to get some ideas:
- You can define the progress of the features
- The progress of the product will be calculated based on the features’ progress
Hope this helps,
Pablo
Thanks for sharing Pablo.
But I can’t see the same in the demo shared by you. It’s view only. Really need help with progress bar.
It’s weird that you don’t see it. It’s in play mode. Try opening in Coda and making a copy.
If your progress is based on the feature’s time remaining then you’ll need to add a formula to a progress column, something like
= (today() - start) / (end date - start date) * 100
to give you the time completed over the total time.
But that will show values over 100% when the end date has passed. So wrap it in an if() statement, like:
If(today()> end date, 100, (today() - start) / (end date - start date) * 100