Configuration of complex reports in Crow Canyon Reports using SharePoint calculated columns:

SharePoint Online:

1. Configure a report to see the average ticket assignment time in hours https://help.crowcanyon.com/article/269

2. Build a report to see the number of tickets created on Weekdays/Week ends https://help.crowcanyon.com/article/270

3. Build a report to see the average number of days tickets are open https://help.crowcanyon.com/article/268

SharePoint On-Premisis:

1. Build a report to roundup a column Elapsed hours into blocks of 5 https://help.crowcanyon.com/article/266

2. Build a report to show Open tickets vs Closed tickets by month https://help.crowcanyon.com/article/265

3. Build a report to show the count of tickets which are created in previous month but closed in current month https://help.crowcanyon.com/article/267