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:
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
Name
Explanation
id
A unique identifier for the work item.
link
The work item's URL
name
The work item's title
<workflow stage name> one column for each
The date the item last entered the specific workflow stage
Blocked Days
Number of days an item has spent blocked.
Blocked
TRUE or FALSE - is the item currently blocked?
<optional fields> one column for each
Additional metadata you would like to include.
Blocked features not supported for Trello Trello has no built in way to denote blocked time and currently it is not possible for us to pull when a label was added or removed for an item. Therefore we cannot currently support Blocked Time features for Trello
the unique identifier 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 stage.
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 blocked
Please see the Workflow Stages chart control below to see how using this control affects this data.
Blocked features not supported for Trello Trello has no built in way to denote blocked time and currently it is not possible for us to pull when a label was added or removed for an item. Therefore we cannot currently support Blocked Time features for Trello
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
This contains information about errors when importing a file
Name
Explanation
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
This only contains information when you experience errors uploading external files.
Decreasing Date errors
To properly analyze flow, you can't have a date in one column that is later than any dates in columns to the right of it in the workflow. In other words, when you move a card backwards, the date in the column it left is removed. It gets a new date when it goes back into that column.
Want to know more about backward flow? Read here for more details.
When importing files, removing long-form text fields will reduce the number of potential formatting issues you may encounter and long-form text isn't really applicable in ActionableAgile.
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
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.
Date Format
Change the date format at any time by navigating to the Settings cogwheel in the top right-hand corner, go down to Date Display and pick your desired format.
Chart Navigation
Here are the new BETA functionalities:
Headers
Both the column header and the ID column are now frozen to make reading the chart easier.
Sorting
You can now sort the data in the chart either by ascending or descending order:
Hover by the name of a column and an arrow will appear, when the arrow points up , the data will be sorted by ascending order. To sort by descending order, click once more on the arrow icon and it will change into a arrow that is pointing down
Highlight
By clicking on a line, it will become highlighted to help scrolling up to the desired information.
Total count
No matter the view you are on, the chart will now display the total numbers of rows