Grouping by specific dates

Looking for ideas on how to approach this challenge.

Preface - I have three years worth of survey data. The surveys were supposed to be open for only two weeks, however some were and some weren't (over two weeks). I have second table with the drop/send dates that vary and do not have any consistency.

Challenge is to use the Send Dates table to alter dates in the Survey Data, if outside any date range change date to max date in the previous date range, if within date range do nothing.

This may be simple but just can't see it right now.

Datasets

Date Time

Help

Time Series

Accepted answers

apathetichell

Hi,

check out my workflow - One potential solution is using an arbitrary cut off value (ie two weeks, 20 days, etc) and then looking at the returns in those period vis-a-vis the date outliers. This version uses a running total of surveys received which you can use versus the number of days the survey was received after survey start date. This allows you to see the bulk of the surveys were received in a certain time period (30 days or so) and the remainder make up a tiny subset of your returns.

Hope this helps.

revised days survey.yxmd

All comments

Luke_C

Hi @Scouter60_RUS

Do you have any sample data? Just reading this I would try the following:

Filter dates outside of the range
Use a summarize tool on the date field to find the max date
Use the append fields tool to add that max date to all records

Scouter60_RUS

Here is a sample of the two data sets. Notice there are multiple date ranges, not just one. The send date plus two weeks makes up each range.

Survey Send Dates.csv

Sample Survey Dates.csv

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703