Help to Write a Report that Shows Average Duration of Tickets (issues) MoM

Question

I'm trying to create an issue report to show the average time between entry date and actual completion date per month. I cannot get any issue duration field to aggregate to show an average in the grouping. I've tried text mode to calculate the date difference, and I've also tried creating a calculated field. Neither is working for me. Is this even possible? If not, does anyone have a good way to show this type of data in Workfront?

Thanks!

MLehman · Accepted Answer

Hi Skye -

As I was getting you the answers to your questions, it dawned on me that I may haven't tried something. It's working now. But for others reading this, I'll put what did and didn't work below.

DID NOT WORK:

aggregator.displayformat=doubleAsString
aggregator.function=AVG
aggregator.namekey=average
displayname=Actual Duration (Days)
valuefield=DE:Actual Ticket Duration
valueformat=doubleAsString

DID WORK:

aggregator.displayformat=customNumberAsString

aggregator.function=AVG

aggregator.namekey=Actual Ticket Duration

aggregator.valuefield=DE:Actual Ticket Duration aggregator.valueformat=customNumberAsDouble

linkedname=direct

namekey=Actual Ticket Duration

querysort=DE:Actual Ticket Duration

valuefield=Actual Ticket Duration

valueformat=customNumberAsString

Thank you!

skyehansen · Answer

can you please post your code, so we can troubleshoot? For the calculated field, can you also confirm that this was formatted to be a number and not text?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded