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

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

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