Source Data

What Is the Purpose of this Chart?

The source data contains all of the data that is available to ActionableAgile. If a chart shows you something unexpected, this is the first place to look. You can see if the chart is rendering this data correctly. If it is but there is still a problem, then we can look and see if there is something wrong with the data transfer from your data source.

We may ask you for your source data to support you with a support issue. If we do, you can remove all unneeded, identifying data to protect your PI.

Key Chart Controls

Data View

You can look at your source data as the full raw file or look at the data through different views. When you select an option other than "Raw (Source Format)", the data updates in the background.

Please note that the Data View "Raw (Source Data) is never affected by the filter controls to the right of the chart. All other Data Views are affected by filter controls.

Click on the expandable links below to learn more about specific data views:

Basic

This contains information needed for a wide variety of charts and for tooltips for individual data points and work items. This data view contains the following data:

Name	Explanation
id	The Azure DevOps key for the individual work item
link	The URL of the Work Item in Azure DevOps
name	The Work Item’s Title
<workflow stage name> one column for each	The date the Work Item last entered the specific workflow stage
Type	The Work Item’s Type
Priority	The Work Item’s Priority
Value Area	The Work Item’s Value Area
Iteration Path	The Work Item’s Iteration Path
Blocked Days	The number of days a Work Item contained a tag of “blocked” (even if only part of a day)
Blocked	Shows TRUE or FALSE depending on if Work Item currently has a tag of “blocked”
Tags	The tags associated with the work item
Reason	The Work Item’s Reason field value, if applicable.
Lane	Name of the swimlane the Work Item is in, if enabled.

Related Link: Identifying Blocked Items

Cycle Time

This contains the information needed for cycle time charts such as the Cycle Time Scatterplot and Cycle Time Histogram. It contains the following data:

Name	Explanation
id	The Azure DevOps key for the individual work item
System	Total elapsed time (in days) that the item took to move through the workflow
<workflow stage name> one column for each	Total elapsed time (in days) that the item spent in that workflow state.
Started	The date the item entered the first checked workflow state
Done	The date the item was completed.
Blocked Days	The number of days the work item contained a “blocked” tag

Please see the Workflow Stages chart control below to see how using this control affects this data.

Related Link: Identifying Blocked Items

Throughput

This contains the information needed for the Throughput Histogram and the Throughput Run Chart. It contains the following data:

Name	Explanation
Date	The date for the data in question
System	The number of Work Items that entered the last checked workflow stage that day
<workflow stage name> one column for each	The number of Work Items that entered the specific workflow stage that day

Work in Progress

This contains the information needed for the Throughput Histogram and the Throughput Run Chart. It contains the following data:

Name	Explanation
Date	The date for the data in question
System	The cumulative number of items in all of your checked workflow stages. This number will be the sum of all of the <workflow stage name> columns for this row
<workflow stage name> one column for each	The number of items in the specific workflow stage

Errors

This contains information about errors when importing a CSV file

Name	Explanation
Reason	A description of the error
Line #	Line in CSV
Column #	Column in CSV
Value	The contents of the cell with the error
Data	The contents of the entire row containing the value

However, you may not see this because the app may block your upload if it is unsuccessful.

'Export Your Data As CSV

To Export your data as CSV file for any reason, simply

navigate to the Controls column to the right,
expand the Export Control, and
click the "Save as CSV" button

Be aware

This export will contain information within the current Data View you've chosen and only that data. To ensure you export all of the data that ActionableAgile for Azure DevOps Services has imported, choose Raw (Source Format) for your data view.

Item Filter

If you would like to filter your data view by any attribute other than workflow stage, use the Item Filter control to manage what is shown in your data view. Please note that the Data View "Raw (Source Data) is never affected by filters.

Workflow Stages

If you would like to filter your data view by workflow stage, deselect the workflow stages you'd like to exclude. Please note that the Data View "Raw (Source Data) is never affected by filters.

If you have any questions about this process, please submit them to our help desk.