Thursday, September 19, 2013

Google Spreadsheet Create a graph of top 5 text strings

Question:

( by Laurie Tewksbury )


How can I count how often text occurs, then create a graphic to shop top the 5 text strings?
I have a list of usernames in a spreadsheet as they contribute to our social media site. I'm hoping to take that list of usernames and find a way to graphically represent the top 5 contributors. A pie graph would be ideal, but a list would work well, too. I'd love for it to update automatically as users continue to contribute to our site. Therefore, it'll always show the top 5 contributing users, but these will change as users contribute more or less.

Is this possible? THANKS!

Solution:


Have a look at the following screenshot of "Sheet1":


Have a look at the following screenshot of "Sheet2":


In the above sheet "Sheet2" I have the following formula in Cell A1:
=query('Sheet1'!A:C;"select C,count(B) where C<>'' group by C order by count(B) desc limit 5 label count(B) 'Total Participation' ";1)


I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.


I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

1 comment: