Calculate averge creation date?

Orbit · 2025-03-17T09:22:23.644Z

Hello bubble,

I have two date filed, Support ticket and Support ticket message with the following data structure:

Support ticket

Screenshot 2025-03-17 at 10.17.06552×724 36.7 KB

Support ticket message

Screenshot 2025-03-17 at 10.14.52527×349 18 KB

What I’m trying to accomplish is to calculate the average time it takes between when a support ticket is created and when a support ticket message (that has support message sender = yes, and is connected to the same ticket) was created.

If i understand correctly, i need to group the search or sort it? I’m not exactly sure but i’d like to display it as average time.

Thankful for anyone that can point me in the correct direction or has the answer

redvivi · 2025-03-17T14:48:28.265Z

I would recommend to convert those dates in UNIX timestamp format. Once done, you may apply any calculation to this list of - now - numbers.

Orbit · 2025-03-17T14:53:00.098Z

Hey @redvivi, thanks for your comment! Would you mind showing me more in detail?

Orbit · 2025-03-18T18:22:24.385Z

Im bumping this, still trying to figure it out

josealex170702 · 2025-03-18T18:34:31.951Z

I think this post solves part of the problem
[Solved] How to show average duration - Need help - Bubble Forum

You can do a search for Support ticket message, format it to text and in the text do the subtraction between the 2 dates you want to compare, you apply split by with | and each item you convert it to a number and take its average

image706×208 15.8 KB

Orbit · 2025-03-18T18:42:32.999Z

Hi, thanks for your comment but how does this compare with the Support ticket message?

This one only creates a average of the tickets created i assume?

josealex170702 · 2025-03-18T18:58:15.813Z

Subtracting the creation date of the Support ticket message with the Support ticket it is linked to. You do this in the format as text in the content to show field and with a delimiter of |

Orbit · 2025-03-18T19:01:55.714Z

Hmm i think i understand but would you mind writing it out because i cant seem to get it to work

hi.luisacosta · 2025-03-19T14:37:35.707Z

Simplify your approach by updating the Support Ticket when the first message is sent with the information you need.

So you can have a field called “First Response” which is date AND then at that exact moment, create a field called “Time To Response” (number type) which will be (First Response) - (Creation Date): formatted as minutes

This will return the minutes as a number.

You can now look through all the Support Tickets and get the average minutes of response time. This works because there is only one “First Response” to a ticket so you don’t need to continually maintain this calculation for the life of the ticket.

Orbit · 2025-03-19T14:49:07.333Z

Hello @hi.luisacosta, thank you for your idea, i think this is actually the best way to do it as you say. Might also reduce some headache in the future… I appreciate your comment