Use the built in field for ‘created date’ to let Bubble track the Case Created Date when the User creates the case in the application.
Use the backend workflow database triggers to setup an automatic workflow when the case status changes to ‘closed’…in that workflow calculate the number of days from the creation date to the status ‘closed’ date and save it to a data field that is a number.
Then you can more easily see and calculate an average number of days for all cases by that User. Search Cases constrained by created by = current user…then from the search results you can use the :sum operator and the ‘/’ using the search results.
Learn More
Boston85719 is an expert Bubbler with a decade experience as an educator. Real name Matthew, he has been actively building SaaS apps, marketplace apps, scheduling apps and more for clients, himself and for sale as templates.
As an official Bubble Bootcamp Instructor, he leads Bubble Bootcamps on a regular basis.
Always willing to offer advice via the Bubble Forum, Matthew also offers Private Personal and Group Training Sessions.
Through his site, NoCodeTrainer, Matthew provides a range of tutorials with editor access to help you jumpstart your Bubble development.
Always accessible you can send Matthew a private message via the forum or send an email directly with your requests.
Be sure to checkout the Stripe Integration Course when you are ready to integrate Stripe payments to start monetizing your application via product sales or subscriptions.
