Welcome @shreyci
currently you are rank each row for itself.
but you want to rank overall. therefore you have to put less fields in the partition part.
Maybe just rank([sum({weighted_score}) DESC])
See also
BR
2 Likes