Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis one is straight forward.
(Edit: Just realised that my solution is simpler compared with many others, as I have used spatial function, thanks to the input data is already a spatial type.)
using the distance function in multirow formula instead.
I was initially trying to create a new column that has the 'spatial' data type but i did not know how so i had to use the solution, which went down a different route which I still don't fully understand how it worked.