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

[MLehman]

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!

[skyehansen]

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?

[MLehman · Accepted solution]

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]

that's great. I often discover a solution when I'm trying to explain my problem to others, so really glad that approach works for you as well.