Skip to main content
System StatusContact Support

Documentation related to the following products will soon be moved to a new portal: (https://docs.digital.ai/)

Digital.ai Agility, Digital.ai Agility Connect and Digital.ai Agility Integrations
Digital.ai Continuum and ALM Connect
Links from the https://community.versionone.com/ site will automatically redirect to the new site.
If you have any questions, please contact Digital.ai Support.

Digital.ai Agility Community

RequestQueries

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