September 2018
Beginner
224 pages
4h 46m
English
A pivot table is a table that summarizes data from another table (such as the result set) by applying an operation such as sorting, averaging, and summing to data in the first table, additionally including grouping and filtering the data by selectable columns.
It allows the user to view the data from various viewing points (pivots), hence the name. The user can change the filter/summary/group and the action of the "pivot" by dragging and dropping the desired columns.
The following pivot table below is based on a slightly modified visualization usage query
select distinct queries.name as "query_name", data_sources.name as "datasource_name", visualizations.type as "visualization_type", count(*) from visualizations join queries ...
Read now
Unlock full access