Counting different items in a column

Thanks again for helping me remove 0 values on my line chart. I have a new question though.

I have a spreadsheet with records of items sold where each row is a different sales entry. I’d like to create a breadboard with best selling products, but don’t seem to be able to. Any help would be greatly appreciated

Hi @Stephen :wave:

It sounds like you are exactly in the situation covered in here https://support.geckoboard.com/hc/en-us/articles/360011225798 If possible, I’d recommend adding a new sheet to perform the calculations like we’ve done here https://docs.google.com/spreadsheets/d/1iKf9lNlfH4319L5oi3NtM0Kg7m28o3qMI74l06yGFho/edit#gid=0 (where we added the sheet “Analysis for Geckoboard” to calculate the data in the “Data” sheet that should be somehow similar to yours).

Let me know how it goes.

1 Like

Thanks. That’s exactly what I needed! I thought the calculations were done in the Geckoboard app. I now see that I need to prepare that in Google Sheets a bit more work I guess but totally doable in my case.