PivotTable Examples
This page demonstrates the key features of interactive PivotTable plots in JSPlots.
- Basic pivot: Simple data aggregation with drag-and-drop
- Custom heatmaps: Color-coded matrices with custom color scales
- Different renderers: Table, Bar Chart, Line Chart, and more
- Data filtering: Inclusions and exclusions to focus on specific data
- Aggregations: Sum, Average, Count, and other aggregation functions
- Combined with other plots: Mix PivotTables with LineCharts and 3D plots
Tip: Drag and drop fields between Rows, Columns, and Values to reorganize!
sales_pivot
Basic pivot table - drag fields to reorganize rows and columns
Data: sales_data
performance_heatmap
Custom color scale heatmap - green indicates good performance, red needs improvement
Data: performance_data
revenue_by_category
Bar chart renderer - switch renderer in the dropdown to see other visualizations
Data: product_data
customer_revenue
Exclusions feature - 'Test' country data is automatically filtered out
Data: customer_data
survey_results
Inclusions feature - only showing ages 18-45, filtering out older demographics
Data: survey_data
transaction_analysis
Count aggregation - showing transaction counts rather than sums or averages
Data: transaction_data
Returns_Over_Last_Few_Days
Stock returns heatmap with MSFT excluded
Data: stockReturns
Correlation_Matrix
Correlation matrix with custom red-white-blue color scale
Data: correlations
Line Chart with Filters
Interactive line chart with dropdown filters - combine with PivotTables!
Filters
Plot Attributes
Data: df_combined
3D Surface Chart
3D surface visualization grouped by mathematical functions
Data: subframe
Key Features Summary
- Drag-and-drop interface: Reorganize data dynamically by dragging fields
- Multiple renderers: Table, Heatmap, Bar Chart, Line Chart, and more
- Custom color scales: Define your own color gradients for heatmaps
- Aggregation functions: Sum, Average, Count, Median, Min, Max, etc.
- Data filtering: Include or exclude specific values
- Multi-level grouping: Use multiple row or column dimensions
- Integration: Combine PivotTables with LineCharts, 3D plots, and more
Tip: Try dragging unused fields from the top into Rows or Columns!
This page was created using JSPlots.jl.