Age of Open Issues by Project, Type, State, Organization, Priority

This chart shows the average age of open issues by project. The age of an issue is the time elapsed since its actual start date if it is defined, or its estimated start date otherwise.

Business Objects	Issues (data model class issue)
Values (or X-Axis and Y-Axis)	X-Axis: Project names. Y-Axis: Average age of open issues, in days.
Sorting	The results are sorted by category count, descending.
Limits	By default, only the top 10 categories are displayed. Note: You can change the pagination to display all the categories by clicking the menu .
Colors	Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views	Bar chart Full screen view Table view
Interactions	On this chart, you can: Draw a rectangular area on the chart using drag-and-drop to zoom on this area. Click an X-Axis label to refine on corresponding category Click to get all results and enable chart pagination. Click to access the different options. Click to add annotations the cart. Click to modify the chart configuration. Click to create an alert. Click to see chart documentation. Click to switch to fullscreen display. Click to switch to table display.
Technical Details	Data model Class: issue Property: issue_estimated_start_date Property: issue_actual_start_date Inherited from document Property: related_project Mashup feed (issues): Aggregation age on facet related_project: AVG(num_opening_days*1.0) Virtual field num_opening_days: #ndays(issue_actual_start_date ?= issue_estimated_start_date, #now())

This chart shows the average age of open issues by problem type. The age of an issue is the time elapsed since its actual start date if it is defined, or its estimated start date otherwise.

Business Objects	Issues (data model class issue)
Values (or X-Axis and Y-Axis)	X-Axis: Problem types. Y-Axis: Average total duration of issues in each category, in days.
Sorting	The results are sorted by category count, descending.
Limits	By default, only the top 10 categories are displayed. Note: You can change the pagination to display all the categories by clicking the menu .
Colors	Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available views	Bar chart Full screen view Table view
Interactions	On this chart, you can: Draw a rectangular area on the chart using drag-and-drop to zoom on this area. Click an X-Axis label to refine on corresponding category Click to get all results and enable chart pagination. Click to access the different options. Click to add annotations the cart. Click to modify the chart configuration. Click to create an alert. Click to see chart documentation. Click to switch to fullscreen display. Click to switch to table display.
Technical Details	Data model Class: issue Property: problem_type Inherited from document Dynamic property: state_duration meta active_duration meta assign_duration meta review_duration meta create_duration Mashup feed (issues) Aggregation on facet issue_problem_type: name: duration expression: AVG((active_duration + assign_duration + review_duration + create_duration)/86400.0)

This chart shows the average age of open issues by current state. The age of an issue is the time elapsed since its actual start date, if defined, or its estimated start date.

Business Objects	Issues (data model class issue)
Values (or X-Axis and Y-Axis)	X-Axis: Problem types. Y-Axis: Average total duration of the issues, in days.
Sorting	The results are sorted by category count, descending.
Limits	By default, only the top 10 categories are displayed. Note: You can change the pagination to display all the categories by clicking the menu .
Colors	There is no color setting.
Available Views	Bar chart Full screen view Table view
Interactions	On this chart, you can: Draw a rectangular area on the chart using drag-and-drop to zoom on this area. Click an X-Axis label to refine on corresponding category Click to get all results and enable chart pagination. Click to access the different options. Click to add annotations the cart. Click to modify the chart configuration. Click to create an alert. Click to see chart documentation. Click to switch to fullscreen display. Click to switch to table display.
Technical Details	Data model Class: issue Property: issue_estimated_start_date Property: issue_actual_start_date Inherited from document Property: current Mashup feed (issues): Aggregation age on facet current: AVG(num_opening_days*1.0) Virtual field num_opening_days: #ndays(issue_actual_start_date ?= issue_estimated_start_date, #now())

This chart shows the average age of open issues by reporting organization. The age of an issue is the time elapsed since its actual start date, if defined, or its estimated start date.

Business Objects	Issues (data model class issue)
Values (or X-Axis and Y-Axis)	X-Axis: Reporting organization. Y-Axis: Average total duration of the issues, in days.
Sorting	The results are sorted by category count, descending.
Limits	By default, only the top 10 categories are displayed. Note: You can change the pagination to display all the categories by clicking the menu .
Colors	Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views	Bar chart Full screen view Table view
Interactions	On this chart, you can: Draw a rectangular area on the chart using drag-and-drop to zoom on this area. Click an X-Axis label to refine on corresponding category Click to get all results and enable chart pagination. Click to access the different options. Click to add annotations the cart. Click to modify the chart configuration. Click to create an alert. Click to see chart documentation. Click to switch to fullscreen display. Click to switch to table display.
Technical Details	Data model Class: issue Property: issue_estimated_start_date Property: issue_actual_start_date Property: to_reporting_organization Mashup feed (issues): Aggregation age on facet issue_to_reporting_organization: AVG(num_opening_days*1.0) Virtual field num_opening_days: #ndays(issue_actual_start_date ?= issue_estimated_start_date, #now())

This chart shows the average turnaround time of issues by priority.

Business Objects	Issues (data model class issue)
Values (or X-Axis and Y-Axis)	X-Axis: Facet categories. Y-Axis: Average total duration of the issues, in days.
Sorting	The results are explicitly sorted.
Limits	There are no limits.
Colors	Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available views	Bar chart Full screen view Table view
Interactions	On this chart, you can: Draw a rectangular area on the chart using drag-and-drop to zoom on this area. Click an X-Axis label to refine on corresponding category Click to get all results and enable chart pagination. Click to access the different options. Click to add annotations the cart. Click to modify the chart configuration. Click to create an alert. Click to see chart documentation. Click to switch to fullscreen display. Click to switch to table display.
Technical Details	Data model Class: issue Property: issue_estimated_start_date Property: issue_actual_start_date Property: priority Mashup feed (issues): Aggregation age on facet issue_priority: AVG(num_opening_days*1.0) Virtual field num_opening_days: #ndays(issue_actual_start_date ?= issue_estimated_start_date, #now())