How to build a report to show the tickets which are created in previous month but closed in current month?

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

 

Leave a Reply