Skip to main content
System StatusContact Support Agility Community


This feature is available in Enterprise and Ultimate editions.

Request Trend

select DateKey, RequestName, RequestStatusName as [Status], count(*) as [Count]
from Fact.Request
    join Dim.AssetState on Fact.Request.AssetStateKey = AssetState.AssetStateKey
    join Dim.Project on Project.ProjectKey=Request.ProjectKey
    join Dim.Request R on Request.RequestKey = R.RequestKey
    join Dim.RequestStatus on Request.StatusKey=RequestStatus.RequestStatusKey
where ProjectName='Call Center'
    and AssetStateName = 'Active'
group by DateKey, RequestName, RequestStatusName
order by DateKey