How to Search: Number of Affected items on Change Orders

I’m trying to figure out if I can run some sort of Advanced Search or report which will show the total number of affected items impacted by the Change Orders approved by a single person.

In other words, I can fairly easily run a search to find out the number of Change Orders that were approved by an individual, but I’m trying to figure out how many items in total were affected by those changes.  

Does anyone have any amazing solutions?

Much appreciated!!!!

Add Comment
2 Answer(s)

It can be done pretty easily with Agile SDK API, will that be fine for you?

Agile Expert Answered on June 1, 2018.
Add Comment

Without scripts or data base queries, I’d maybe do some Excel comparisons.  Ultimately it’ll be two searches though because you can’t search the workflow tab with affected items tab on the same search.  

This search gets you all ECOs approved by a certain person.  You can also run a User Signoff Duration Report for this same data. 

RE: How to Search: Number of Affected items on Change Orders

Then simply conduct another search for all changes w/ affected items number as one of the columns. Export that and pivot for number of affected items for each ECO. 
Then finally compare both spreadsheets using VLOOKUP.

Agile Angel Answered on May 4, 2018.

Matt, 
  Thanks for the suggestion!  It’s a creative solution to something that should be seemingly simple.  So unfortunately, I work for a huge company and the number of Change Orders within the timeframe I’m looking for is quite large.  I had already successfully run the exact search you showed in your example prior to posting the question, but in trying the second search you described, Agile is not pleased with me.  I’ve been sitting here “waiting” for about 10 minutes and think my search crashed.   I’m on the bottom of the totem pole here, so my ability to call “upstairs” for help are pretty limited. 

I’ll keep trying with maybe a smaller date range and see what happens.  I tried searching for those COs with only a specific change analyst too, and it still didn’t like it.  

Appreciate you offering a suggestion though!!

Regards,
J

on May 4, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.