Greetings,
I have a report I've been using on a daily basis (below) to see how many tickets different agents are closing each day. I'm trying to build this report so that every Friday afternoon a report goes out showing how many tickets we closed from the previous 5 days (Monday to the current Friday). Unfortunately, my learn-as-I-go report building skills aren't getting me where I need to be. Any help would be appreciated. I love the results the report I'm posting below gives me, I'd just like to see it for the past 5 days instead of just one day.
Select Top 1000000 htblticket.ticketid As ID,
htblticket.subject As Subject,
htblticket.updated As [Closed Date],
Sum(htblnotes.timeworked) As [Time Worked (Minutes)],
htblusers.name As Agent,
htbltickettypes.typename As [Ticket Type],
DatePart(mm, htblticket.updated) As Month,
DatePart(dd, htblticket.updated) As Day,
DatePart(yy, htblticket.updated) As Year
From htblticket
Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Where DatePart(mm, htblticket.updated) = 06 And DatePart(dd, htblticket.updated)
= 23 And DatePart(yy, htblticket.updated) = 2017 And
htblticketstates.statename = 'Closed'
Group By htblticket.ticketid,
htblticket.subject,
htblticket.updated,
htblusers.name,
htbltickettypes.typename
Order By Agent
