A Pivot Table stores the summary of a specific data set in a condensed manner or groups data together in a meaningful way. My personal favorite is to treat Pivot Tables as raw data export tables into Excel and Google Sheets for detailed analysis.
1. Pivot Table
In this chart, we are displaying Users by Age Group and Users Type for the selected time range.
Recommended: Yes [Table A]
Both Pivot Tables and Tables can handle large data sets and in most cases, these two types of charts are the most suitable choice for displaying an extensive data set.
2. Pivot Table With Bars
In this chart, we are displaying Users by Age Group and Users Type for the selected time range.
Recommended: Yes [Table A]
Both Pivot Tables and Tables can handle large data sets and in most cases, these two types of charts are the most suitable choice for displaying an extensive data set.
3. Pivot Table With Heatmap
In this chart, we are displaying Users by Age Group and Users Type for the selected time range.
Recommended: Yes [Table A]
Both Pivot Tables and Tables can handle large data sets and in most cases, these two types of charts are the most suitable choice for displaying an extensive data set.
4. Pivot Table With Bars: with "Expand — collapse" option
"Default expands level." Is fixed and not possible to deselect (country in the below example). Secondary expand level can be selected or deselect (Continent and Sub-Continent in the above example)
Recommended: No
Hard to digest the data and structure for most of the users. Please avoid "Expand —collapse" in a Pivot Table
[Expand — collapse] — it's recommended that this is avoided — even after working in the Data Analytics field for over eight years, I still find this confusing! However, if you do choose to use it, this operates similarly to Optional Dimensions for other charts, though there is no way to deselect the default dimension. An example is shown below.
- Scorecards
- Pie/Doughnut Chart
- Bullet Charts
- Gauge Charts
- Line Charts/Time Series Charts
- Column Charts
- Combo Charts
- Table
- Pivot Tables
- Area Charts
- Scatter Charts
- Bubble Chart
- Geo Maps Charts
- Treemap
- Bullet Chart vs Gauge Chart
Configuration across chart:
- Background and Border
- Missing Data
- Conditional Formatting
- Chart Header
- Legends
- Reference Lines
- Report Settings
Most Used Features: