Database Reference
In-Depth Information
CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688
BETWEEN @StartOfMonth AND @EndOfMonth THEN 1 END),0)
AS CreatedThisMonth,
ISNULL(SUM(CASE WHEN
ResolvedDate_D2A4C73F_01B8_29C5_895B_5BE4C3DFAC4E
BETWEEN @StartOfToday AND @EndOfToday THEN 1 END),0)
AS ResolvedToday,
ISNULL(SUM(CASE WHEN
ResolvedDate_D2A4C73F_01B8_29C5_895B_5BE4C3DFAC4E
BETWEEN @StartOfWeek AND @EndOfWeek THEN 1 END),0) AS
ResolvedThisWeek,
ISNULL(SUM(CASE WHEN
ResolvedDate_D2A4C73F_01B8_29C5_895B_5BE4C3DFAC4E
BETWEEN @StartOfMonth AND @EndOfMonth THEN 1 END),0)
AS ResolvedThisMonth
FROM
MT_System$WorkItem$Incident WITH (NOLOCK)
5. Under
Datasets
, add a dataset named
DSOpenUnassigned
(this is shown in
the next screenshot). Select the
Use a dataset embedded in my report
option,
select the
ServiceManager
data source, select
Text
query type, and type the
following query. Then, click on
OK
: