Can I show an average for a "time to convert issues" report | Community
Skip to main content
M
mdeancherry
New Participant
May 2, 2025
Solved

Can I show an average for a "time to convert issues" report

  • May 2, 2025
  • 2 replies
  • 376 views

I've got a report that shows how long it's taking our account managers to convert a request to a project. The "Time to Convert" column was created in text mode:

displayname=Time to Convert
linkedname=direct
querysort=entryDate
valueexpression=ROUND(DATEDIFF({entryDate},{actualStartDate}),2)
valueformat=HTML

I don't get an "average" option for the column, like I do if I use a standard column selected from the drop down. Is there any way to display the average for the column other than exporting to Excel? I'm using groupings based on the different account managers, if that makes any difference. 

Thanks.

Best answer by skyehansen

I think your most satisfying option will be to make a calculated field with your expression above, and then average based on that field.

2 replies

kautuk_sahni
kautuk_sahni
Employee
July 29, 2025

@mdeancherry Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

Kautuk Sahni
skyehansen
skyehansenAccepted solution
New Participant
May 3, 2025

I think your most satisfying option will be to make a calculated field with your expression above, and then average based on that field.

    Terms & ConditionsAccessibility statement

    Loading footer...