IssueQueries

This topic explains how use the issue queries in Agility.

Issue Trend

            select DateKey, IssueName, IssueCategoryName as [Category], count(*) as [Count]
            from Fact.Issue
            join Dim.AssetState on Issue.AssetStateKey = AssetState.AssetStateKey
            join Dim.Project on Project.ProjectKey=Issue.ProjectKey
            join Dim.Issue I on Issue.IssueKey = I.IssueKey
            join Dim.IssueCategory on Issue.CategoryKey=IssueCategory.IssueCategoryKey
            where ProjectName='Call Center'
            and AssetStateName = 'Active'
            group by DateKey, IssueName, IssueCategoryName
        order by DateKey