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.

The Fact.Issue table captures information about daily changes to Issues. Each row in the table represents a single Issue on a given day. All metrics in the table are semi-additive, meaning that are cumulative only for a given day. Supported Custom Fields are also available on this table.

Table Description

The following table describes the columns available in the default table.

Column Name Description Datatype Foreign Key To
DateKey Date of this measure int Dim.Date
IssueKey Datamart identifier for the Issue int Dim.Issue
ProjectKey Datamart identifier for the project containing this issue int Dim.Project
TeamKey Datamart identifier for the team assigned to this issue int Dim.Team
OwnerKey Datamart identifier for the member responsible for this issue int Dim.Member
ResolutionKey Datamart identifier for the issue resolution int Dim.IssueResolution
SourceKey Datamart identifier for the source of this issue int Dim.WorkitemSource
PriorityKey Datamart identifier for the issue priority int Dim.IssuePriority
CategoryKey Datamart identifier for the issue category int Dim.IssueCategory
AssetStateKey Datamart identifier for the asset state of this issue int Dim.AssetState