Source Data

IN PROGRESS

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 Jira Issue's Key
link	The Jira Issue's URL
name	The Jira Issue's Summary
<workflow stage name> one column for each	The date the item last entered the specific workflow stage
Type	The Jira Issue's Type
Priority	The Jira Issue's Priority
Fix Versions	The Fix Version(s) that the Jira Issue belongs to
Components	The Component(s) that the Jira Issue belongs to
Assignee	The display name of the assignee of the Jira Issue
Reporter	The display name of the reporter of the Jira Issue
Resolution	The Jira Issue's Resolution
Labels	A pipe-delimited list of labels associated with the Jira issue
Blocked Days	The number of days an item was flagged in Jira (even if only a portion of the day)
<optional fields> one column for each	You can import custom fields when configuring your Jira data in AA. Each of those fields imported will have a column and will contain the value of that field from the Jira Issue.

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 Jira key for the individual work item
System	the total elapsed time (in days) that the item took to move through the workflow
<workflow stage name> one column for each	the 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 item spent as flagged in Jira

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

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 items that entered the last checked workflow stage that day
<workflow stage name> one column for each	The number of 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 will 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 Jira has access to, 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.