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

[mdeancherry]

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.

[skyehansen · Accepted solution]

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

[kautuk_sahni]

@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!