Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
This doesn't look like you need above(), it looks like you need below()?
tried that as well