RequestQueries

This topic explains how to use the request queries in Agility.

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