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

Analytics Grids

  1. Last updated
  2. Save as PDF
This feature is available in Ultimate edition only.

editions-u.png

Overview

Analytic Grids expand on the Quicklist reports available in the core Digital.ai Agility application. In addition to Quicklist features such as customization, filtering, sorting, and exporting; Analytic Grids give you the ability to group data and aggregate values and provides support for charts and cross tabulation tables. Finally, grid configuration can be saved and shared across the organization.  

Analytic Grids are available for portfolio items, stories/backlog items, defects, test sets, tasks, tests, effort, and backlog matrix.  

Accessing Analytics Grids

  1. On the side bar, click the Analytics icon analytics_icon.png.

  2. Click Analytic Grids and select any of the following tabs:

    • Portfolio Item

    • Backlog

    • Story

    • Defect

    • Test Set

    • Task

    • Test

    • Effort

    • Backlog Matrix

Common Grid Functionality

The following image, taken from the Story Grid, shows the common controls to all Analytic Grids.  These controls are used to determine what data is presented and how that data is presented.

AnalyticGridsControls2.png

The following table describes the controls used to select the data presented in the grid.

Name

Description

Default Value

Project

Determines which projects are considered.  This filter is explained in more detail in the "Scope Selection" section on the Dashboards page.

Highest level project visible to the current user

Program

Determines which projects are considered.  This control is only visible when your Digital.ai Agility instance contains Programs.  This filter is explained in more detail in the "Scope Selection" section on the Dashboard page.

None

AsOf Date

The date to be used when selecting data.

Today

Managing Views

AnalyticGridsControls2.png

The following table describes the controls used to manage save view.

Select View

Opens a dialog containing saved views.  This dialog has two tabs, one that contains view you saved (My Views) and another that contains views saved by other people in your organization (Global Views).   On the My Views tab, you can also delete views that you created.  

  • To select a view, click on the My Views tab or Global Views tab, and then click on a name.

AnalyticGridsSavedView.png

Reset View

Reset the grids to the default view.

Save View

Save the current view. 

Customizing Data Presentation

The following sections describe the controls used to customize how data is presented.

Formula

Allows you to add a custom column to the grid that is based on a formula.  The Column Name is specified in the Name field and the Formula is specified in the Formula field.  Use the "Insert a column" dropdown along with the "Insert" button to add columns to the formula.  The "Data Type" and "Display Format" are used to control how the data is presented.  Additional information on supported formula is available on the Formula Help page.

AnalyticsGridFormula.png

Filter

Allows you to filter the data visible in the grid.

AnalyticGridsFilter.png

Add Chart

 

Allows you to add charts to the grid page.  Once you select a chart type, you are prompted for the data elements to include.  Charts are added below the table by default, but can be moved to the top.

AnalyticsGridAddChart.png

Add Crosstab

Allows you to add a cross tabulation, or pivot, table to the page. Crosstab tables are always positioned below the grids.

AnalyticsGridAddCrosstab.png

Table AnalyticGear.png

The Layout configuration panel allows you to show and hide columns on grid.  The column order is changed by dragging the column headers.  You do not open the Layout Panel to change column order.

Columns

AnalyticsLayout.png

Sort

Allows you change how the data is sorted in the grid.

AnalyticsSort.png

Group

Allows you to control how the grid data is grouped. 

AnalyticGridsGroup.png

Aggregate

Allows you aggregate the grouped data. The Aggregate functions available are: Sum, Average, Standard Deviation, Count, Distinct Count, Minimum, Maximum.

AnalyticGridsAggregate.png

Paging

Allows you to enable/disable paging and determine the number of rows on a page.  Paging is enabled by default and the default rows per page is 20.

AnalyticGridsPaging.png

Backlog Matrix

The Backlog Matrix presents a multidimensional view of Stories, Defects, and TestSets.  

AnalyticGridsBacklogMatrix.png

Each bar chart in the grid only includes the data represented by the row and column intersection.  Using the controls at the top of the page, you can control: the x- and y- axes of the Bar chart, the aggregate function used to determine the bar height, the row and column grouping and you can filter the data presented. 

Clicking on any chart open a larger view of that chart.

AnalyticGridsBacklogMatrixZoom.png

Clicking on the Details button, presents a table of the data that can be exported to Excel.

Please note that Text Fields are not available in Analytic Grids. We do not display text fields on Grids because they are not trended over time and we use an AsOf date on the grids to look across time.