Google Charts - MySQL php

hope all is well!


I need some guidance I have a MySQL Table which looks like this

I would like to have a drop-down list of the companies (facebook, google and youtube) - When I select for example: "google" from the drop-down list, it would display the results for each username who has "google in their row. Then count how many there are total for each user. I would like to have the results show for each day, a full month and a full year totals. It would also be very nice to somehow show each time each company was hit by that user. That's why I added the timestamp.

I would want this to show in some kinda nice graph bar chart. I thought of using Google Charts. Maybe there is something better? Maybe easier to work with?

I'm not here posting this to ask for someone to just code this for me, i'm asking for some help to start me out! Any help is appreciated!

I hope this make sense! haha. This seems very complicated for me to code but I love a challenge but I'm pulling my hair out trying to figure this one out.

Thank you,
Timothy