It 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:
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.