Editing pivot table

The pivot table widget can be preconfigured as any other widget or, in UI mode, let users do their own pivoting with the underlying data table.

Configuration

The configuration is similar to a table widget. Currently, only data from a data source or data query can be selected.

Setting	Description
Enable UI	Fields can be selected and configured for pivoting by dashboard user (edit mode not required)
Global floating point precision	Specify the decimal places used. Can be overwritten by colum definitions

By switching Enable UI on or off, different features will be available.

Drag & drop columns from the widget header to the x and y axis of the pivot table.

Adjust vertical and horizontal sort order by the two arrow buttons.

Filter data using the column drop downs. Single values can be toggled on or off. By clicking only, all other values are deactivated.

Select numeric value columns and aggregate functions from the dropdown menus.