Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

On our website we record thousands of events in tables each with a unique timestamp. Is there a tool that can plot for me the number of timestamps that fall within a day, week, or month, on a graph a-la-google analytics, to help me understand the trends?

share|improve this question
1  
What tables are we talking about here? MySQL? PGSql? Sqlite? logarithm tables? dining tables? –  Majenko Mar 18 '11 at 14:54
    
or are we talking about events that goes into the log files? –  Johan Mar 18 '11 at 15:43
    
In this case, stored in MySQL tables, but they essentially resemble log files. –  chrism2671 Mar 18 '11 at 16:44

2 Answers 2

If you want a simple graphing tool, take a look at Graphite.

If you on the other hand want do do complex analysis, you would best use some sort of OLAP tool. I personally know Pentaho a little bit, which is an open source business analytics tool.

With Pentaho, you could use the Kettle/Spool ETL (Extract-Transform-Load) tool to aggregate your data. Using the Mondrian Schema Designer you could then describe your data structure to Pentaho.

Finally, within the Pentaho dashboard you'll find the Marketplace, where you can install open source tools to create dashboards or create dynamic queries via the Saiku-UI

I realize this is not your click-and-go solution, but in the long run you will get a lot more value out of this solution than a simple graphing tool.

share|improve this answer

Since the data is already stored in a SQL database, you might look at SQL Reporting Services. It's not difficult to get it up and running, though a little coding knowledge will go a long way here.

This article gives an example very similar to your dataset:
http://rduclos.wordpress.com/2010/02/13/ssrs-2008-generate-calendars-based-on-a-date-range/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.