How can I set up a workflow to count the number of items in a list?

Question

I am trying to set up using a SharePoint 2010 workflow that will count the number of non priority 1 tickets in a custom SharePoint online list. What I would like to have it do is go through the list, if the ticket is priority 1 then it will print the current total into the column. Then, if it is priority 2-5 it will add one to the total and update the total column. It would look something like this

Title     Priority     Total 
Ticket 1     1          0 
Ticket 2     3          1 
Ticket 3     3          2 
Ticket 4     1          2

I can't seem to get the workflow to work quiet like that and I was wondering if someone could help. Here is how my current workflow is set up

Answer 1

You can do this using following logic.

1. If current item priority = 1. Then get recently modified list item where priority equals one. From that item take the total value and assign it to a variable.

   • Increment value in variable and update current item Total field

2. Else. Get recently modified list item where priority is not equal to one. From that item take the total value and assign it to a variable.

   • Increment value in variable and update current item Total field