Previous in Script or Above in UI Table..need assistance

[pradnya_avrioc]

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

[Or]

This doesn't look like you need above(), it looks like you need below()?

[pradnya_avrioc]

tried that as well