One of the great features about the google visualization api we use in our html5 dashboards, is the ability to perform client side, run time group by operations. Unlike Xcelsius, which does not provide this functionality, this ability allows us to get all the data we need in one trip to the server, and then using group by aggregate the detailed data in different levels for different presentation needs. In the example below, i got some sample data (from eFashion…) and am using different group by options to aggregate the measurements, revenue and margin, by different dimensions in the dataset. All the data is retrieved from the database once, when the page loads, and the rest of the magic happens in the browser memory, no server calls involved. This example also includes the ability to toggle the chart presentation with a map, and the ability to view the full data set (all 4715 rows of it). Enjoy.