Like the name suggests, Quick Pivot allows you to quickly perform "pivot-table" transform on a report's result dataset.
After running your query, you can pivot the table by selecting the 'quick pivot' option in the report editing page under the SQL Editor panel.
Given the following table that stores your pageviews traffic data:
A simple select to get your pageviews by traffic:
will get you something like this:
'Quick Pivot' allows you to instantly generate this, which is a lot easier to consume (and visualize).
A few notes on how it works:
- It uses the last column as the measure values (numbers)
- It uses the second last column as the dimension to be pivoted
- You can have as many remaining columns on the left as you want.
To use, you'll find an option for 'quick pivot' in the report editing page, under Preview panel.
Yes but. You'll have to write more troublesome SQL queries like this:
And even so, when new traffic source comes, you'll have to modify the report's query to cater for new cases.
Quick Pivot allows you to pre-transform the queried data, and after that you can apply a graph (Line Chart, Column Chart, etc) to it.
Pivot Visualization is a visualization itself based on the data queried.