Sorting and Running Total

[anna0anel]

Hello all!

I am trying to keep track of a 3 month survey effort with data coming in DAILY,  my goal is to send a weekly summary of the results.

How can I achieve the following

• Sort info by week (there is a completion date attached to all incoming data)
• As the weeks go by keep a running total of the results (simple sum, average and percentage of completion)

Any help or direction is welcome! I already have my workflow put together on how I would like to present the data, I now just need to sort it.

[CharlieS]

@anna0anel

Do you have some sample data that could show what the input looks like?

[anna0anel]

Here is a small sample - the data will be coming from a database that over the next few months should grow significantly

District	TownName	MapNumber	INDs Found	GAPs Found	Completed	SRVY_DATE
YELLOW	B	AG436984	8	7	0	2018-05-14
TAN	G	112	5	28	1	2018-05-23
TAN	G	113	8	15	1	2018-05-23
TAN	I	127	20	28	0	2018-05-21

Thanks for the help!

[CharlieS · Accepted solution]

@anna0anel

Check out the attached workflow and let me know if that gets you started in the right direction. Here's the formula used to get week from a Date field:

DateTimeFormat([SRVY_DATE],"%U")

//Use "%U" for Week assignment beginning on Sunday
//Use "%W" for Week assignment beginning on Monday

[anna0anel]

This is great - Thanks so much :)