In the ShufflePoint query tool, you can generate a Google Visualization data provider URL on the "Google Gadgets" tab of the interface. Using this URL in combination with a query allows one to populate data into a Google Visualization gadget.
The first sample shows the result of sending this query to a table gadget.
TRANSFORMS REPLACE [(/|/Default\.aspx)$] WITH [/Default.aspx] SELECT METRICS ga:visits ON COLUMNS DIMENSIONS ga:pagePath, ga:pageTitle ON ROWS TOP 10 NOOTHER BY ga:visits FROM [www.shufflepoint.com] WHERE TIMEFRAME yearToDate
Of note in this query is the TRANSFORM clause to tell the engine to merge the pagepaths "/" and "/Default.aspx"
The table gadget is configured to sort on the first (and only) data column which is the visits count. It also specifies to sort descending. The Table gadget configuration options are documented here.
If you look at the output, you see that page path and page title were combined and placed in a single cell. The reason is that by default ShufflePoint generates a generic pivot table which can feed tables and charts. If you desire to place each dimension in its own column, you need to "flatten" the table. This is accomplished by editing the data provider URL generated by the query tool.
Change
gaql2vis.aspx?key=...
to
gaql2vis.aspx?f=jsonflat&key=...
Now the output looks like this.
If you view the page source, you will see that the sort column was changed to "2" because now the data column comes after the non-data "page title" column.
Finally, if you use the Table gadget, remember to make use of the teriffic formatters which are available. See the reference doc on formatters: http://code.google.com/apis/visualization/documentation/reference.html#formatters