--- title: "Source Data Chart" canonical: "https://support.55degrees.se/space/SP/4313251871/Source%20Data%20Chart" format: markdown --- [Jira Cloud & Data Center] [Azure devops] [standalone] ![Screenshot 2026-05-25 at 11.09.29.png](media://801f81fd-d490-4247-ad59-0e23b739a561) The **Source Data Chart** provides a detailed, tabular view of the raw data that underpins your flow metrics and charts. It is an essential tool for validating your data, troubleshooting anomalies, and gaining granular insights into your workflow. > ℹ️ 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. We may ask you to export your source data to help resolve a support issue. If we do, remember to remove all unneeded identifying data to protect your PI. ### Navigation #### Header Both the column header and the ID column are frozen to make the chart easier to read. ![Screenshot 2026-05-25 at 11.23.53.png](media://c26714bf-32ab-412a-b036-efdafe58b570) #### Sorting You can sort the data in the chart either by ascending or descending order: ![image]() Hover over the name of a column, and an arrow will appear. When the arrow points up ⬆️, the data will be sorted in ascending order. To sort by descending order, click once more on the arrow icon ⬇️, and it will change into an arrow that is pointing down     #### Highlight By clicking on a line, it will become highlighted to help scrolling up to the desired information. ![image]() #### Total count No matter the view you are on, the chart will now display the total number of rows (how many unique items were loaded). ![image]() > ℹ️ **ActionableAgile Analytics respects your existing user permissions **when loading data from Jira or Azure DevOps. This means that if you're trying to load data shared with you or data from a restricted project or location, you may see fewer items than expected. If the results look incomplete or unexpected, permission restrictions could be the cause. --- ### Chart Controls > Macro (refined-tabs) > > > Macro (refined-tab) > > 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. > > ![image-20260528-121318.png](media://37953594-19f4-445b-9693-c14357d4509d) > > **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 | A unique identifier for the work item. | > | link | The work item's URL | > | name | The work item's title | > | > 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? | > | > one column for each | Additional metadata you would like to include. | > > > **Cycle Time** > > This contains the information needed for cycle time charts such as the [https://support.55degrees.se/space/SP/4312957014](https://support.55degrees.se/space/SP/4312957014) and [https://support.55degrees.se/space/SP/4355457048](https://support.55degrees.se/space/SP/4355457048). 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 | > | > 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 | > > > **Throughput** > > This contains the information needed for the [https://support.55degrees.se/space/SP/4367908868](https://support.55degrees.se/space/SP/4367908868) and the [https://support.55degrees.se/space/SP/4363059215](https://support.55degrees.se/space/SP/4363059215). 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 | > | > 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 [https://support.55degrees.se/space/SP/4367908868](https://support.55degrees.se/space/SP/4367908868) and the [https://support.55degrees.se/space/SP/4363059215](https://support.55degrees.se/space/SP/4363059215). 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 columns for this row | > | > one column for each | The number of items in the specific workflow stage | > > > ℹ️ Want to know more about **backward flow**? [Read here](https://support.55degrees.se/space/AAS/846331967/How+does+ActionableAgile+handle+work+that+moves+backwards+in+the+workflow%3F) for more details. > > ℹ️ We also have a great blog post on the [impact of moving cards backward on a Kanban board](https://www.55degrees.se/blog/post/moving-cards-backwards-on-your-kanban-board). > > > Macro (refined-tab) > > To Export your data as CSV file, simply: > > - Navigate to the Controls column to the right, > - Expand the Export Control, and > - Click the "Save as CSV" button > > ![image]() > > > ⚠️ **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. > > > ℹ️ If we request an export of your Source Data to help us troubleshoot a data issue, please remove all unnecessary identifying data to protect your PI. > > > Macro (refined-tab) > > 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.* > > Please see the Workflow Stages chart control below to see how using this control affects this data. > > ![Screenshot 2026-05-25 at 11.51.52.png](media://fd289ca4-7e49-4027-9e0a-366aaee982b7) > > > Macro (refined-tab) > > 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.* > > ![image]() > > > Macro (refined-tab) > > | | | > | --- | --- | > | Change the date format at any time by navigating to the Settings cogwheel in the top right-hand corner, go down to Date Format and pick your desired format.
😉 Once you pick your date format, **ActionableAgile Analytics will remember it,** so you don’t have to keep updating it. | ![image]() | > > > Macro (refined-tab) > > This All Charts Control allows you to choose a static dates or rolling period of time, so you can see data from a specific date range. Every Flow Insight will adhere to the date range that you choose. > > - To get **Static Dates**, select directly on the Visible Period’s calendar or manually enter the dates you want in the designated boxes below. These dates will remain the same, hence the *static*. > - For a **Rolling Period**, pick one of the pre-made options to the right of the Visible Period’s calendar. This period will update to the current day, hence the *rolling*. > > ![Screenshot 2026-05-28 at 15.56.34.png](media://98640ef6-6399-4af8-af2c-4de342fb8ea6) --- > ℹ️ Pro tip: 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 Analytics. --- ❓ 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/](https://support.55degrees.se/) . We would love to hear back you think!