Pivot Toolbar
Last updated
Last updated
Can viewers be restricted to selecting or changing only dimensions and not measures?
Yes, within the 'Edit Toolbar' popup, accessible by clicking the corresponding button in the design panel, you have the flexibility to determine whether viewers can alter dimensions and measures. The configuration options also include the ability to set a maximum limit on the number of dimensions and measures that can be selected concurrently.
How can I enable the Pivot Toolbar for all pivots?
Enabling the Pivot Toolbar for all pivots can be achieved through the configuration file. In the config file, locate the 'enableToolbarByDefault' option. Setting this option to 'true' will activate the toolbar by default for all existing pivots that don't have explicit settings and for new pivots created thereafter.
Can I customize the appearance of the button to match my dashboard colors?
Absolutely! Within the 'Edit Toolbar' popup, there's a dedicated tab specifically for customizing buttons. In this tab, you have the freedom to adjust various elements such as button width, color, text, and background color.
The Pivot Toolbar Plugin for Sisense introduces a dynamic and user-friendly interface to enhance the functionality of the pivot widget within the dashboard. This specialized plugin empowers viewers by providing them with the ability to customize their data visualization experience. Users can effortlessly add or remove dimensions and measures from a predefined set, tailored by the dashboard designer. The intuitive drag-and-drop feature allows viewers to seamlessly modify the pivot widget to meet their specific analytical needs. Once configured, a prominent button appears at the top of the pivot widget, serving as a gateway for users to access and choose dimensions and measures with ease.
To enable the Pivot Toolbar for a specific pivot widget in Sisense, designers can navigate to the pivot widget's design panel. In the design panel, locate the 'Show Toolbar' toggle button, which is initially disabled by default. Designers can enable this toggle, and upon activation, the 'Edit Toolbar' button becomes accessible. If, for any reason, these options are not immediately visible when creating a new pivot, designers should save the pivot configuration and then re-enter the edit mode to reveal the toolbar options.
Upon clicking the 'Edit Toolbar' button, a popup window will open, presenting users with a comprehensive set of configuration options for the Pivot Toolbar Plugin. The popup window is organized into two distinct tabs. The first tab is dedicated to 'Toolbar Settings,' allowing users to fine-tune the functionality and behavior of the toolbar. The second tab is labeled 'Header Styling,' providing users with options to change the look and feel of the button displayed at the top of the pivot widget.
Allow Viewers to Change Measurements: The first toggle button, labeled 'Allow Viewers to Change Measurements', empowers viewers with the flexibility to modify measures based on their analytical needs when enabled. If disabled, viewers will be restricted from changing measures.
Allow Viewers to Change Dimensions: The second toggle button 'Allow Viewers to Change Dimensions' pertains to dimensions, offering designers the ability to enable or disable viewers from changing dimensions within the pivot widget. When enabled, users can freely adjust dimensions to explore data from different perspectives. Disabling this option restricts viewers from altering dimensions.
Max Selected Dimensions and Measures: To provide additional control, the settings tab includes separate options for both measures and dimensions, allowing designers to set a maximum limit for the number of measures and dimensions that viewers can select simultaneously.
The 'Header Styling' tab provides designers with a range of customization options for the Pivot Toolbar Plugin's button displayed atop the pivot widget. In this tab, designers can personalize the button text, set the popup title, adjust button width, and define background, hover, and text colors.
Once the configuration is finalized and the dashboard is shared, viewers will encounter a prominently placed button at the top of the pivot widget. Clicking this button triggers a popup window tailored to the configuration settings. Within the popup, viewers are presented with two distinct sections for measures and dimensions based on the predefined configuration. In the 'Select Data' section under measures, viewers can conveniently choose any measure from the comprehensive list integrated into the pivot. Simultaneously, in the 'Select Rows/Columns' section under dimensions, three sub-sections—Unused, Rows, and Columns—facilitate intuitive customization. Viewers have the flexibility to drag and drop dimensions among these sections, tailoring the display to their specific analytical needs. Unused dimensions can be conveniently placed in the 'Unused' section.
enableToolbarByDefault: Enable the toolbar by default for all existing pivots without explicit settings and for new pivots as well.
