Report on Previous month tickets carry forwarded to current month
Applies to: SharePoint On-premises and SharePoint Online.
Requirement: To build a report to show the tickets which are created in previous month but closed in current month.
Steps:
1. Create below calculated columns in the Tickets list.
| Title | Formula | Return type |
| NextMonthFirstDay | =DATE(YEAR(Created),MONTH(Created)+1,1) | Date Only |
| NextMonthLastDay | =DATE(YEAR(Created),MONTH(Created)+2,0) | Date Only |
| ClosedButDelayed | =IF([Closed Date]>=[NextMonthFirstDay], "Yes", "No") | Single line of text |
2. Create a view with filter conditions like shown below.
– This view can be either used in Crow Canyon Report Center or Tiles webpart to see the count of tickets which are created in previous month but closed in current month. Refer "Calculated Table" or "Tiles" section in this URL for more details: http://www.crowcanyon.info/manuals/webparts/index.html
For more sample reports refer https://www.crowcanyon.help/article/239
