I have a table which shows the final score for each project and I am required to stack rank them.
Current formula I’m using ends up throwing 1 for all the lines.
rank([sum({weighted_score}) DESC], [{project_id},{project_name},{project_owner},{project_sponsor},{project_description}],POST_AGG_FILTER)
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