Can we calculate # days assigned a team-(e.g., Build team v. QA team) Is there a formula to calc assigned to Build for x-days and to QA for y-days?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We've been asked to calculate how long a ticket has been assigned to one team - and how long it is assigned to another team. (e.g., when the Build team v. the QA team should have been working on the ticket.)
Right now we'd key off of the Assigned To field - but it may be easiest to create a new field that identifies the Assigned To name as being either Build or QA, to just have 2 values to filter off of.
I then need to calculate that a ticket was assigned to Build for x-days and assigned to QA for y-days.
Is this possible to do? Can you help me with a formula to create this?

Bonus points: if there is a way to know it was assigned to Build team for 3 days, then QA for 2 days, then BACK TO the Build team for 4 more days. (A way to know it "bounced", rather than just saying the Build team had it for 7 days.)

Photo of Laura


  • 0 Points

Posted 3 years ago

  • 0
  • 1
To do this effectively, you will need to have a child table of Status changes to record who has the ball and what the status of the ticket is.  Then float up the value of the most recent status update child up to the patent Ticket record using a reverse relationship based on the max record ID# of the child records.

I can show you a demo of this technique if you like.  Contact me via the information in my profile if you would like to see a demo.