2 Replies Latest reply: Jun 13, 2018 3:00 AM by Prasad P

# Repeat Case Analysis - 7days (Above & Below - Dates)

Count of repeat cases for past 7 days and next 7 days interval. count will varry day by day.

Example Data:

 Sn No Date Case 1 1/1/2018 23456 2 1/1/2018 34567 3 1/1/2018 67891 4 1/1/2018 91011 5 1/1/2018 91011 6 1/2/2018 01234 7 1/2/2018 23456 8 1/2/2018 34567 9 1/2/2018 67891 10 1/2/2018 91011 11 1/2/2018 131415 12 1/3/2018 23456 13 1/3/2018 34567 14 1/3/2018 89101 15 1/3/2018 89101 16 1/3/2018 91011 17 1/3/2018 131415 18 1/4/2018 01234 19 1/4/2018 01234 20 1/4/2018 12345 21 1/4/2018 67891 22 1/4/2018 89101 23 1/4/2018 91011 24 1/4/2018 111213 25 1/4/2018 121314 26 1/4/2018 141516 27 1/4/2018 151617 28 1/5/2018 12345 29 1/5/2018 23456 30 1/5/2018 45678 31 1/5/2018 56789 32 1/5/2018 78910 33 1/5/2018 111213 34 1/5/2018 121314 35 1/5/2018 131415 36 1/5/2018 141516 37 1/6/2018 45678 38 1/6/2018 56789 39 1/6/2018 89101 40 1/6/2018 101112 41 1/6/2018 101112 42 1/6/2018 121314 43 1/7/2018 12345 44 1/7/2018 45678 45 1/7/2018 45678 46 1/7/2018 56789 47 1/7/2018 56789 48 1/7/2018 78910 49 1/7/2018 91011 50 1/7/2018 131415 51 1/7/2018 141516 52 1/7/2018 151617
• ###### Re: Repeat Case Analysis - 7days (Above & Below - Dates)

What is the expected output based on the above sample data?

• ###### Re: Repeat Case Analysis - 7days (Above & Below - Dates)

Basically need to get a count of cases which is repeated for above and below 7 date (Rolling Days).

Ex: Case 91011 is there on 1/1/2018, 1/2/2018, 1/3/2018, 1/4/2018

Date          Case     Count     Day wise Interval Count

1/1/2018   91011       1                      4

1/2/2018   91011       1                      4

1/3/2018   91011       1                      4

1/4/2018   91011       1                      4