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://www.crowcanyon.help/article/269

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

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

SharePoint On-Premisis:

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

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

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