Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a table
Load * Inline [
Team, Name, Win, Rank
A, Wladimir, 31, Team Lead
A, Paul, 22, Technical Support Engineer
B, Mark, 40, Customer Support Engineer
B, Janne, 27, IT Specialist
];
for each team i need to find the the name of most numbers of Win of the team and use the rank of that name to get a new table as below
Team ,Rank
A,Team Lead
B ,Customer Support Engineer
was thinking to do
rank : only({<Name={"rank(sum(win),1)=1"}>} rank) but not wworking
i tried a lot of things now my brain stopped working, maybe someone can help me with a solution?
thanks!
To avoid nested aggregation issue, use aggr(), like:
FirstSortedValue( Rank, -Aggr(Sum(.....), Team))
Dim : Team
Rank (Exp) : FirstSortedValue( Rank, -Win)
Hi @tresesco
thank you for your prompt response, i tired it, my win was a sum of something, and firstsortedvalue does not allow nested aggregation.
any other suggestions please?
.
.
To avoid nested aggregation issue, use aggr(), like:
FirstSortedValue( Rank, -Aggr(Sum(.....), Team))