Working out a percentage (%)

Dear community

I know there are some really talented people in this community and I’m wondering if one of you can help me out.

I have a list of 1000 things, the fields inside that thing are;

date created
date completed

I want to calculate the percentage % completed within 30 days of the created date.

How would this look in bubble? Any help in calculating a percent would be excellent.

Kind regards

Tim Garrett

Do a search for Questions
Date Created > Current Date + (days -30)
Status is Completed
:count / Do a search for Questions
Date created > Current date + (days -30):count*100

This will get all questions completed that have created date within 30 days divided by all questions within 30 days and multiply by 100 to have percentage


Thanks @Jici

You are a star!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.