getting top five from array

[czarj]

I have a function that gets the number of submitted tickets for each user. How do I make this get the top five submitters (and their respective ticket totals) and lump the rest of the count into "other." This data is being pulled from a database. thanks!

var user_burt_count = [];
for ( var i=0; i < data.length; i++ ) {            
                var submitter = data[i].sub_by;
                if( !( submitter in user_burt_count ) ) {
                                user_burt_count[submitter] = 1;
                }
                else {
                   user_burt_count[submitter]++;
                }
}

--- You must not fight too often with one enemy, or you will teach him all your tricks of war.

 

[feherke]

Hi

Well just sort them, then sum all starting at 5[sup]th[/sup] item.

In this code you will have the resulting top 5 + 1 elements in object top :

[b]var[/b] order = Object.keys(user_burt_count).sort([b]function[/b](a, b) {
  [b]return[/b] user_burt_count[ignore][b][/ignore] - user_burt_count[a]
})

[b]var[/b] top = {}, other = 0
[b]for[/b] ([b]var[/b] i = 0, l = order.length; i < l; i++)
  [b]if[/b] (i < 5)
    top[order[ignore][i][/ignore]] = user_burt_count[order[ignore][i][/ignore]]
  [b]else[/b]
    other += user_burt_count[order[ignore][i][/ignore]]

[b]if[/b] (other)
  top[[green][i]'other'[/i][/green]] = other

See it in action on

http://jsfiddle.net/LLkM8/

.

If I misunderstood you, please clarify the requirements.


Feherke.
feherke.ga

 

[czarj]

perfect, thanks!

--- You must not fight too often with one enemy, or you will teach him all your tricks of war.