Loading your Azure DevOps Data
What you’ll find in this document:
You can now load by Query!
How to Load Data in Azure DevOps
Navigate to the Data Set drop-down menu and select Create New Data Set.
Create a data set
Step 1: Select Work Items
This action will kick off step one of the new data loader, where you will choose what data you want to load.
Firstly, choose a unique name for your data set that is less than 50 characters in length.
- Secondly, choose whether you want to load via Query, Board or Team(s).
For Query, select the pre-made Query you wish to view.
For Board, select the Team and the corresponding Board you want to view.
For Team(s), select the Team(s) you want to view.
“Get Cross-Project Work Item History”, what does this mean? Well, if you have work items that have migrated across Azure projects that you have access to, and you want to be able to map it’s journey, you can check this option for ActionableAgile Analytics to get your work items history from across all the Azure projects you have access to.
Loading by Query:
You can now create data sets from your previously crafted queries in Azure DevOps.
You can see data from your issues' entire history and not just that of what is on the current board.
Loading by Board:
It will show only the data related to the chosen board.
Loading by Team(s):
You can see data from your issues' entire history and not just that of what is on the current board.
You do not lose historical data when you make changes to your board design.
You can measure flow for multiple teams at once allowing a higher-level view of flow.
Next, if you chose Board or Team(s), you’ll see the Nested Area Paths.
You can edit them by selecting “Change”.
Area Path information won't show up when you load data through a query because the query itself should be specific enough.
Lastly, choose whether you want to apply filters that limit your data to items Created After and/or Resolved After a chosen date.
Once you've settled on the parameters for the data you want to load, go ahead and click "Next."
Step 2: Add Fields
We automatically bring in these Default Fields: ID, Issue Link, Title, date, Work Item Type, Priority, Value Area, Area Path, Iteration Path, Blocked Days, Blocked, Tags, Reason, Lane, Removed From
From the list of available fields on the left-hand side, choose the field(s) you wish to bring into your data set.
Please note you can select (and deselect) multiple fields in one go.
Once you have chosen your fields, select the top arrow to add them to your data set.
Your chosen fields will now appear in the right-hand column.
To remove any fields from your data set, simply select the desired fields and click the bottom arrow to remove them.
Once you have selected your preferred fields for the data set, click “Next.”
Step 3: Map Workflow Stages
Begin by mapping your columns or states to the workflow stages.
Where the data is mapped will determine how your data is visualised in ActionableAgile.
Unmapped columns or states need to be mapped in your workflow.
Each column or state contains transition dates for your work items, so it’s best to map them to your workflow to ensure all work items have their journey through your workflow plotted correctly.
Don’t recognise some columns or states? ActionableAgile goes through the entire history of your work items to grab all the transition dates. This includes workflows from which your item may have been migrated and columns or states that may have been deleted or renamed.
You can customise your workflow to visualise your data how you want by renaming, merging, and creating new workflow stages to map your data to.
Once you have mapped your data and organised your workflow, click “Finish.” Your data set will now be loaded into ActionableAgile Analytics and you’ll be able to view the saved version in Find or Manage A Data Set.
Find or Manage A Data Set
To view your saved data sets in ActionableAgile for Azure DevOps, navigate to the data set drop-down menu and select Find Or Manage A Data Set.
You can also take some quick actions if you have a data set loaded.
Selecting the will favourite your data set, permanently adding it to the data set drop-down menu until your unfavourite it.
Selecting will refresh the data set.
Selecting will allow you to edit your data set.
Selecting will allow you to delete your data set.
After you have selected Find Or Manage A Data Set, a window will appear with all the data sets you have saved, their names, the last date they were updated, and actions you can take (view, edit, and delete).
Selecting the name of your data set will load your data set.
Selecting will allow you to rename your data set.
Selecting will allow you to edit your data set.
Selecting will allow you to delete your data set.
Load a data set
Navigate to “Find or Manage Data Sets” and click on the data set you wish to load.
Your data is now loaded!
If you have any questions about this process, please submit them to our help desk.
Related articles