Export data to excel from State graph in devops

%3CLINGO-SUB%20id%3D%22lingo-sub-2364384%22%20slang%3D%22en-US%22%3EExport%20data%20to%20excel%20from%20State%20graph%20in%20devops%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2364384%22%20slang%3D%22en-US%22%3E%3CP%3EApologies%20I%20am%20new%20in%20a%20company%20and%20using%20Azure%20devOps%20for%20the%20first%20time...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20follow%20a%20sprint%20lifecycle%20in%20for%20each%20user%20story%20as%20it%20passes%20from%20developments%20to%20test%20to%20production.%20I%20would%20like%20to%20be%20able%20to%20get%20dates%20from%20azure%20to%20track%20how%20long%20this%20takes...%26nbsp%3B%20I%20want%20to%20export%20the%20data%20captured%20as%20part%20of%20the%20state%20graph%20for%20all%20user%20stories%20or%20for%20a%20selection%20of%20sprints.%26nbsp%3B%20I%20would%20like%20a%20column%20set%20something%20like%20this%20...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20picture%20attached%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20criteria%20columns%20names%20might%20be%20as%20follows%20and%20the%20data%20is%20in%20the%20%5B...%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%20UserID_%5Bnumber%5D%2C%20Uer%20story_%5BTitle%5D%2C%20Sprint%20iteration_%5Bnumber_16%5D%2C%20new_%5Bdate%20created%5D%2C%26nbsp%3B%20moved%20to%20QA%5Bdate%20created%5D%2C%20inproduction%5Bdatedeployed%5D%20etc%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20excel%20plugin%20but%20this%20doesn't%20seem%20to%20help.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20ever%20done%20this%20before%3F%20or%20have%20any%20idea%20where%20i%20might%20start.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Apologies I am new in a company and using Azure devOps for the first time... 

 

We follow a sprint lifecycle in for each user story as it passes from developments to test to production. I would like to be able to get dates from azure to track how long this takes...  I want to export the data captured as part of the state graph for all user stories or for a selection of sprints.  I would like a column set something like this ... 

 

See picture attached 

 

So criteria columns names might be as follows and the data is in the [...]

  UserID_[number], Uer story_[Title], Sprint iteration_[number_16], new_[date created],  moved to QA[date created], inproduction[datedeployed] etc 

 

I have excel plugin but this doesn't seem to help.  

Has anyone ever done this before? or have any idea where i might start.

 

 

0 Replies