I have a website link tracking table that has the following fields:
I would like a query to report back link_id, number of total hits, number of uniqe hits, browser types(counts). The report would by usual table output, but each line should have a link to produce a detailed report and graph.
The report should be an output to csv or excel with all of the data, and the graph should be a pop-up timeline that can be customized in real-time (with a calendar parameter for timeline AND a interval (minute, hour, day, week, month, etc).
If you look at google analytics, you'll understand what type of chart I'd like.
Also, in a similar table, I'll have a list of phone numbers. I would like to compute the number within each area code and plot them onto a USA chart? I believe googleapi has this chart in their inventory. Please add that to the project.