Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
FirstSortedValue Not showing First "TOP USER" in textbox when two users have the same value. For example if Tom has 10 sessions and Harry has 9, my top user will display Tom, which is correct. If Tom and Harry both have 10, it doesn't show no one.
I've come across this before but it will take the first sorted by alphabet, how can i sort this out to only show one user?
Regards
='TOP USER: ' & FirstSortedValue([Name], -aggr(count( Session), [Name]))
Apologizes, I forgot to add closing parenthesis for Rank function
='TOP USER: ' & FirstSortedValue([Name], -aggr(Count( Session) + Rank([Name])/1E10, [Name]))
or
='TOP USER: ' & FirstSortedValue([Name], -aggr(Count( Session) - Rank([Name])/1E10, [Name]))
May be this:
='TOP USER: ' & FirstSortedValue([Name], -aggr(Count( Session) + Rank([Name])/1E10, [Name]))
not sure if it needs to be + or -, try both
='TOP USER: ' & FirstSortedValue([Name], -aggr(Count( Session) - Rank([Name])/1E10, [Name]))
That's giving me an error in the expression
it may be because you have more than one customer with the same weight / rank , FirstSortedvalue will return null in that case
I know that bit, I'm trying to resolve how to sort it, possibly by sorting by alphabet.
Apologizes, I forgot to add closing parenthesis for Rank function
='TOP USER: ' & FirstSortedValue([Name], -aggr(Count( Session) + Rank([Name])/1E10, [Name]))
or
='TOP USER: ' & FirstSortedValue([Name], -aggr(Count( Session) - Rank([Name])/1E10, [Name]))
Thanks Sunny T, yet again
Happy New Year Guys
Happy New Year!!
Sunny,
You are dividing Rank([Name]) / 1E10 and what does 1E10 refers to ?
Thanks
1E10 = 1/10,000,000,000 (1 divided by 10,000,000,000)