Issue report for queue (duration in queue) | Community
Skip to main content
KatColbourn
KatColbourn
Level 2
October 30, 2023
Question

Issue report for queue (duration in queue)

  • October 30, 2023
  • 2 replies
  • 570 views

Hello,

I've seen some similar questions in the community.  I'm trying to build a report that will identify how long an issue has been in the queue  (Initiation to project conversion).


I have been successful in a) creating custom calculated fields that can provide this info and b) creating a report that can calculate duration based on status.

 

Option A:  loads up the admin section of the form with many extra fields which I'm trying to avoid (if possible). 

Option B:  if an issue is converted to a project, the issue cannot be closed so the timer keeps going.

 

I feel like there must be an easier way.  Note: I could not get a journal entry report to work.  

 

Thank you!

Kat

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

KellieGardner
Community Advisor and Adobe Champion
KellieGardnerCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 30, 2023

Option A: can you add a section break into the custom form to make that section only viewable by certain individuals?  

https://experienceleague.adobe.com/docs/workfront/using/administration-and-setup/customize/custom-forms/custom-form-builder/use-the-custom-form-builder/add-a-section-break-to-a-custom-form.html?lang=en#how-multiple-object-types-can-affect-section-break-permissions-in-a-custom-form


Option B: Could you filter out issues that have been converted to projects to avoid them showing on the report?

NicholeVargas
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
October 30, 2023

@katcolbourn Just to help clarify things, are the following statements correct? You want to see: 

  • If an issue has been converted to project, calculate number of days between entry date and resolving project entry date
  • If an issue has not been converted to project & issue status is not equal to closed, calculate number of days between entry date and $$TODAY
  • If an issue has not been converted to project & issue status equals closed, calculate number of days between entry date and actual completion date
Terms & ConditionsAccessibility statement

Loading footer...