Burn down - ticket report
Using Cireson Analytics: I was looking to create a "burn down report" IE a variance between week to week of tickets that get closed.
Example(this is in excel as part of manual process in excel) 1) The top row would be active tickets of the week - minus the ones we closed during the week 2): Resolved will be resolved for the week 3) would be created for the week 4) (this is the tricky part) 4 - is how many tickets we closed week to week -- please let me know if you have questions on this!
What I have so far in SQL:
@vYear AS INT,
/* Set the @vYear variable to the year you are analyzing */
@vYear = year(getdate())
@vJan1Year = DATEADD(yyyy, @vYear - 1900, 0)
@vDec31Year = DATEADD(yyyy, @vYear - 1899, 0)
@vJan1Year AS DateOfYear
DATEADD(d, 1 ,cte_Fridays.DateOfYear)
DATEADD(d,1,cte_Fridays.DateOfYear) < @vDec31Year
[CiresonAnalytics].[dbo].[SR_IR] AS t
(t.[CompletedDate] IS NULL OR t.[CompletedDate] > cte_Fridays.DateOfYear)
t.[Created] < cte_Fridays.DateOfYear
DATENAME(dw, DATEADD(d, 0 ,cte_Fridays.DateOfYear)) = 'Friday'
My issue is that I do not see that velocity the way I would need it and ran into my stumbling block. Thank you for any assistance!