Loading your Azure DevOps Data
- Julia Wester
- Margaux Fiche
- Jonas Wester (Unlicensed)
- Eloise Vinson
You can now save data sets!
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 Board Columns or Workflow States.
For Board, select the Team and the corresponding Board you want to view.
For Work Items, 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 Workflow States:
You can now see data from your issues' entire history and not just that of what is on the current board.
You are no longer forced to 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.
You can now look at data from multiple teams at once!
Loading by Board Columns:
It will show only the data related to the chosen board.
Next, pick the Nested Area Paths that you would like to use.
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
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.
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.
After you have selected this, 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 are now loaded!
If you have any questions about this process, please submit them to our help desk.
Related articles