Urgent - Median line on scatter chart - need to plot based on each day

[sayadutt]

Hello team,

I am trying to show a Median in the below graph.

While searching older posts, I see that we can plot the Median using the reference line option in Presentation tab. (The line shown in Red below).

My requirement is, to show the daily median as well, instead of a straight horizontal line.

Basically, to find the median of each dots for a particular date and then plot them as well (along with existing dots).

Also to join these individual medians (based on daily value) and show the trend.

Can you please guide me.

If not possible directly via Scatter graph, if there are any workaround available to show the same. Even by modifying Edit Script?