Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:




Expand
titleBasic

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

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. 

Note

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



Expand
titleCycle 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 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.

Note

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


Expand
titleThroughput

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



Expand
titleWork 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



Expand
titleErrors

This contains information about errors when importing a 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

This only contains information when you experience errors uploading external files. 

Panel
bgColor#DEEBFF

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

Info

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 this data set, 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.

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.

Screenshot 2024-01-18 at 14.15.05.pngImage Added

Chart Navigation

Here are the new

Status
colourPurple
titleBETA
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

❓ Do you have any questions?

⚠️ Is something not working the way it should?

☝️ Do you have any feedback?

Please reach out to our support team via https://support.55degrees.se/. We would love to hear back you think!