AnsweredAssumed Answered

Collecting and reporting on items that have a certain value in a field?

Question asked by calmaguer on May 15, 2017
Latest reply on May 17, 2017 by murphybp2

I have a list of items that have a due date and a completed date.  I already have logic that does the calculation, and determines whether a 10 day SLA has been met, and populates an "SLA met?"  field with a Yes/No  and an "SLA +/- Days" field (gives me a zero or negative number if the SLA was met or exceeded, and a positive number if the SLA was missed).

 

Now what I would like to do is schedule a workflow to run weekly and report out on the items that were completed in the previous 7 days, and whether the SLA was met for each or not and by how much.

 

I figure I need to use a site workflow so that I can schedule it.  I also figure I need to Query List, filter for show items when column SLA Met = Yes, and store it in a collection variable.  I can get these items into a notification, but I don't know how to limit the collection to just items that were completed in the past 7 days.

Outcomes