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?
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.
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.