| – Grid |
|
| Virtual grid that ensures smooth rendering and scrolling the rows |
|
| Sort the members of the rows and columns |
|
| Sort by values |
|
| Drag and drop the hierarchies on the grid |
|
| Drill through the cells |
|
| Drill the hierarchies up and down |
|
| Expand and collapse the hierarchies on the grid |
|
| Resize the rows and columns on the grid |
|
| Grand totals and subtotals |
|
| Compact pivot table |
|
| Classic pivot table |
|
| Flat table |
|
| Add multiple fields to the rows |
|
| Add multiple fields to the columns |
|
| Add multiple fields to the measures |
|
| Create multilevel hierarchies |
|
Select the string field as a measure (with count or distinctcount aggregation applied) |
|
| Select cells |
|
| Copy selected cells |
|
| Keyboard shortcuts to navigate on the grid |
* |
| Highlight the rows and columns via the conditional formatting |
|
| – Filter |
|
| Filter by members using the checkbox |
|
| Filtering by members using the search input box |
|
| Filtering by value (Top X records) |
|
| Filtering by value (Bottom X records) |
|
| Report filters |
|
| – Fields |
|
| Adding and editing calculated values via UI |
|
| Dragging fields in the Field List |
|
| Displaying hierarchy levels in the Field List |
|
| The Expand All option in the Field List |
|
| The Field List in the drill-through pop-up window |
|
| – Aggregation functions |
|
| “sum” |
|
| “count” |
|
| “distinctcount” |
|
| “average” |
|
| “median” |
|
| “product” |
|
| “min” |
|
| “max” |
|
| “percent” |
|
| “percentofcolumn” |
|
| “percentofrow” |
|
| “index” |
|
| “difference” |
|
| “%difference” |
|
| “stdevp” (Population Standard Deviation) |
|
| “stdevs” (Sample Standard Deviation) |
|
| “runningtotals” |
|
| – The Toolbar |
|
| Save a report |
|
| Open a report |
|
| Conditional formatting |
|
| Number formatting |
|
| Connect to a CSV data source |
|
| Connect to a JSON data source |
|
| Full-screen mode |
|
| – Export |
|
| Print reports |
|
| Export reports to HTML |
|
| Export reports to MS Excel |
|
| Export reports to PDF |
|
| Add custom headers and footers (PDF, HTML) |
|
| Add custom sheet names (Excel) |
|
| – Options |
|
| Language localization |
|
| Apply a pre-defined report theme |
|
| Date and time patterns |
|
| – Integration with charting libraries |
|
| amCharts |
|
| Highcharts |
|
| Google Charts |
|
| FusionCharts |
|
| Any charting library |
|
| – Integration with frameworks and web technologies |
|
| React |
|
| Angular |
|
| Vue |
|
| Django |
|
| Jupyter |
|
| Flutter |
|
| jQuery |
|
| AngularJS |
|
