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.