Report on the Trend; duration to resolve over a period of time.

[EpenetusN]

i am trying to create a report with the following characteristics:

1. a trend that shows the duration to resolve incident tickets over days, weeks, months, years

[soumyadeep10]

Hi @EpenetusN ,

Check the below report with a line chart and if it seems fine to you, please configure accordingly.

Also, one more thing, I have created a custom function field called 'Resolution Duration':

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

[EpenetusN]

Thank you so much, so were you able to trend by the "Resolution field" you just created.

[soumyadeep10 · Accepted solution]

Hi @EpenetusN , I don't think it's possible to trend by a custom function field, but one thing I can suggest, you can create a custom field that does the same job instead of creating this function field. Then you would be able to add it in the Trend by. 
Also, you can play around with what I've created to see what happens.

Please mark my solution as accepted if you think it was helpful for you. It would be of great help for others as well.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

[AndersBGS]

Hi @EpenetusN ,

and what have you tried so far and where are you failing?