Spreadsheet-like visual editor allows developers to visually design stunning-looking, responsive and interactive visualizations: from simple kpi to interactive fancy and stunning-looking "table-like" data views (with the ability to build custom multiline detailed views).
The "Dimensions/Measures" panel automatically opens up when new visualization created. "Apply all" button allows developers to apply and use all dimensions and measures configured on the data sections of the property panel. It also applies predefined set of actions like "Sort", "Alternative dimensions/measures", "Searchable dimension", "Select dimension value", etc.
To create a custom visualization template, you should add columns/rows, merge cells, resize columns and rows in accordance with the design requirements. Quick add buttons allow to easily add columns / rows.
To change column width it needs to hover mouse pointer over a divider between columns and holding left mouse key change the width by dragging it to the right or to the left (to increase or decrease column width). In a same way a row height can be changed.
It is possible to set or change column width (or row height) by clicking a special icon or width label shown over the column number (to the left of a row number). Popup window will arise and help to set, change or clear column width (or row height).
You should bind dimensions and measures with the custom template, and then apply various style options – fonts, alignment, borders, colors, backgrounds. To bind a dimension or measure with the template just double click on a cell or use Ctrl + Space (⌘ + Space) to open dimensions and measures popup menu and then select an appropriate item. As an alternative, developers can use "Dimensions/Measures" data panel.
Editor context menu can be used to increase a developer productivity. Toolbar panel can also be collapsed to increase the working area and expanded again if need it.
To preview visualization, click “Preview” tab at the top of the toolbar.
To open up the PowerKPI editor a developer should click on a button
in the top left corner of the component or, as another option, open Visualizations sections on the property panel and then expand an appropriate visualization and click on the "Edit template" button.
In the top left corner of the toolbar panel there is a button which allows a quick and easy switch between visualization templates (if several visualizations have been created in one component).
“Custom objects” tab allows you to preview and apply a predefined visualization template.
on the toolbar panel of the editor allows you to open up a menu, which allows copying, exporting and importing designed templates as well as opening template properties panel ("Show properties" menu item).
A developer can use "Export" button to export developed template into a file, and then import it in another component using "Select file..." menu item. In such a way, developers can create own visualization templates library in the form of files on a drive.
To open a template properties panel use "Show properties" menu item.
Properties panel allows to apply “Fit to height” parameter, which will shrink or stretch a visualization to fit the occupied by the component area. It is recommended to set this option on visualization templates without dimensions only.
"Scrolling" option allows to choose between Native or Virtual scrolling mode for tables. Native mode is used when "Scrolling" option is set. Native mode uses native pageable scroll in which the "Load more" or "Load previous" buttons can be used to load the next or previous page of the data, while virtual scrolling mode allows to scroll the entire dataset.
“Background image” allows adding an image as a background for templates.
“Thumbnail” allows setting a thumbnail for templates.
"Fit to height" mode can also be applied with the help of a quick button in the visual editor (see image below).
The toolbar also has buttons to “undo/redo” changes and a “Save” button, along with template and hypercube titles.
The visualization template is displayed in a spreadsheet-like view with cells below the toolbar.
To be able to merge cells, you should select cells from the top left cell to the bottom right cell holding the left mouse button.
To apply some operations on several cells, you should select them holding "Ctrl" key.
To select an entire column, you should click the column header (the cell with the column number). In such a way, by clicking the row number, you can also select the entire row. It is possible to select several columns/rows by selecting the corresponding column/row headers.
Main operations are grouped by sections on the toolbar:
“Cells” operations allow you adding/removing cells, as well as changing cells settings;
- “Data” section contains operations which will allow you to bind data items (dimensions and measures), apply actions, insert text, icons, images;
- “Borders” will allow you to set borders and border styles on cells;
- “Alignment” will allow you to align data horizontally and/or vertically;
- “Font” will allow you to apply font, size and styles/text behavior options.