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.

Sorting and Running Total

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.

Workflow

Datasets

Preparation

Accepted answers

CharlieS

@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

20180601-WeeklySurveyResults.yxmd

All comments

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703