Skip to main content
System StatusContact Support
VersionOne Community

IssueQueries

This feature is available in Enterprise and Ultimate editions.

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
  • Was this article helpful?