Hi,
I wish to create PREV_DATE and PREV_EVENT_ID from Event_result_date and Event_id.
I have tried Below, Above, Only, Aggr, Max(date,-1) on QS table - not giving any result
Previous in Script: for 6/11/2023 it give 6/4/2023 whereas it should give me 5/28/2023.
Kindly help.
| # |
PLAYERNAME |
EVENT_RESULT_DATE |
event_id |
PREV_DATE |
prev_event_id |
| 1 |
Pradnya |
06/11/2023 |
5f55193c-edc9-478d-ae80-0a1c25cd82e6 |
05/28/2023 |
8a284956-a982-45e1-b52e-a6a40eab48cc |
| 2 |
Pradnya |
05/28/2023 |
8a284956-a982-45e1-b52e-a6a40eab48cc |
05/21/2023 |
17ac8f4f-9465-4164-8341-3847902dcdec |
| 3 |
Pradnya |
05/21/2023 |
17ac8f4f-9465-4164-8341-3847902dcdec |
05/14/2023 |
34ea605a-7798-4fe6-87fb-e57f6959b853 |
| 4 |
Pradnya |
05/14/2023 |
34ea605a-7798-4fe6-87fb-e57f6959b853 |
04/23/2023 |
432dda7f-2fb6-4d2d-925e-0c47a97f0d71 |
| 5 |
Pradnya |
04/23/2023 |
432dda7f-2fb6-4d2d-925e-0c47a97f0d71 |
04/16/2023 |
5a631753-5687-434f-97ef-2b1aee795d84 |
| 6 |
Pradnya |
04/16/2023 |
5a631753-5687-434f-97ef-2b1aee795d84 |
04/02/2023 |
28efe6a8-5971-434e-a571-71dd29119908 |
