Skip to main content
System StatusContact Support

Documentation related to the following products will soon be moved to a new portal: ( Agility, Agility Connect and Agility Integrations Continuum and ALM Connect
Links from the site will automatically redirect to the new site.
If you have any questions, please contact 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