Summarizing control chart data with queries

Steve DaumIt may seem arcane to some folks – but I enjoy a good query challenge. Recently, a customer needed help with a query to aggregate raw data into a useful form for charting. Since I’ve helped several customer do almost the same thing, I decided to write a short article for our Knowledge Base. Here is the link:

http://www.pqsystems.com/kb/activekb/questions/540/A+simple+query+pattern+for+summarizing+raw+data

If you want to chart data where several rows get summarized for each data point – this article contains example SQL queries. These make good patterns for solving a large class of data summery problems. Don’t let the SQL queries intimidate you – it is pretty simple once you see a few examples. The article includes a download containing example data and example CHARTrunner charts.

Happy querying!