Spreadsheet: 726363d1617193986-adding-lagged-factor-exampledataset-insertdelay
Sheet: Sheet1

CountryName | Date | Difference | Delay 15 days
Aruba | 2020-01-01 00:00:00 | 0.2857142857142857
Aruba | 2020-01-02 00:00:00 | 0.2857142857142857 |  |  | 20 days are given per country
Aruba | 2020-01-03 00:00:00 | 0.2857142857142857 |  |  | Delay 15 days' hat to provide the the difference of 15 days later
Aruba | 2020-01-04 00:00:00 | 0.2857142857142857 |  |  | For the first 5 days it's easy
Aruba | 2020-01-05 00:00:00 | 0.2857142857142857 |  |  | But for the last 15 days, we just want the latest available data of that specific country and not of the next country
Aruba | 2020-01-06 00:00:00 | -0.1428571428571428
Aruba | 2020-01-07 00:00:00 | 0.1428571428571429
Aruba | 2020-01-08 00:00:00 | 0.1428571428571429
Aruba | 2020-01-09 00:00:00 | 0.1428571428571429
Aruba | 2020-01-10 00:00:00 | 0.1428571428571429
Aruba | 2020-01-11 00:00:00 | 0.1428571428571429
Aruba | 2020-01-12 00:00:00 | 0.1428571428571429
Aruba | 2020-01-13 00:00:00 | 0
Aruba | 2020-01-14 00:00:00 | 0.1428571428571428
Aruba | 2020-01-15 00:00:00 | 0.1428571428571428
Aruba | 2020-01-16 00:00:00 | 0.1428571428571428
Aruba | 2020-01-17 00:00:00 | 0.1428571428571428
Aruba | 2020-01-18 00:00:00 | 0.1428571428571428
Aruba | 2020-01-19 00:00:00 | 0.1428571428571428
Belgium | 2020-01-01 00:00:00 | -6.428571428571445
Belgium | 2020-01-02 00:00:00 | -6.428571428571445
Belgium | 2020-01-03 00:00:00 | -6.428571428571445
Belgium | 2020-01-04 00:00:00 | -6.428571428571445
Belgium | 2020-01-05 00:00:00 | -6.428571428571445
Belgium | 2020-01-06 00:00:00 | -4
Belgium | 2020-01-07 00:00:00 | -5.857142857142861
Belgium | 2020-01-08 00:00:00 | -5.857142857142861
Belgium | 2020-01-09 00:00:00 | -5.857142857142861
Belgium | 2020-01-10 00:00:00 | -5.857142857142861
Belgium | 2020-01-11 00:00:00 | -5.857142857142861
Belgium | 2020-01-12 00:00:00 | -5.857142857142861
Belgium | 2020-01-13 00:00:00 | -6.285714285714306
Belgium | 2020-01-14 00:00:00 | 1
Belgium | 2020-01-15 00:00:00 | 1
Belgium | 2020-01-16 00:00:00 | 1
Belgium | 2020-01-17 00:00:00 | 1
Belgium | 2020-01-18 00:00:00 | 1
Belgium | 2020-01-19 00:00:00 | 1
Belgium | 2020-01-20 00:00:00 | 14.71428571428572
Bangladesh | 2020-01-01 00:00:00 | 0.7142857142857144
Bangladesh | 2020-01-02 00:00:00 | 0.7142857142857144
Bangladesh | 2020-01-03 00:00:00 | 0.7142857142857144
Bangladesh | 2020-01-04 00:00:00 | 0.7142857142857144
Bangladesh | 2020-01-05 00:00:00 | 0.7142857142857144
Bangladesh | 2020-01-06 00:00:00 | 0.4285714285714288
Bangladesh | 2020-01-07 00:00:00 | -0.5714285714285712
Bangladesh | 2020-01-08 00:00:00 | -0.5714285714285712
Bangladesh | 2020-01-09 00:00:00 | -0.5714285714285712
Bangladesh | 2020-01-10 00:00:00 | -0.5714285714285712
Bangladesh | 2020-01-11 00:00:00 | -0.5714285714285712
Bangladesh | 2020-01-12 00:00:00 | -0.5714285714285712
Bangladesh | 2020-01-13 00:00:00 | -1
Bangladesh | 2020-01-14 00:00:00 | -1.428571428571429
Bangladesh | 2020-01-15 00:00:00 | -1.428571428571429
Bangladesh | 2020-01-16 00:00:00 | -1.428571428571429
Bangladesh | 2020-01-17 00:00:00 | -1.428571428571429
Bangladesh | 2020-01-18 00:00:00 | -1.428571428571429
Bangladesh | 2020-01-19 00:00:00 | -1.428571428571429
Bangladesh | 2020-01-20 00:00:00 | -1.142857142857142