BloX Template: Dynamic Pivot Table

[intapiuser]

Introduction:

The Dynamic Table template allows you to create a pivot table which dynamically sizes columns based on the size of the browser.

This template is structured for 4 columns, each of which are set to 25% of the column set size, which changes based on the browser window.

LARGE BROWSER WINDOW:

SMALLER BROWSER WINDOW:

Installation Instructions:

1. Download the attached template
2. Import template and choose the downloaded file:

3. Refresh your browser

4. Create a new Blox Widget and open the Templates menu under the design panel.

You should now be able to see and choose the new template.

If you cannot see the template in the All Templates menu, please restart the Sisense.blox service on your Sisense server.

Populate the Items and Values panels with relevant fields and aggregations. Please note that any change in panel item names should be reflected in the card editor.

Technical Notes

CAROUSEL

To show items stacked vertically instead of via the default carousel view, the carousel is set to false in row 8 of the Editor. 

"showCarousel": false

HEADER

To configure a header to only repeat for the first carousel item, see line 2 in Editor where the title is not loaded for all items with class "blox-pivot-title" which is specified for each column header TextBlock.

except the first based on class.

 "style": ".blox-slides:first-child .blox-pivot-title{display:block; !important;} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}"

SEPARATOR

Separator attributes (color, thickness) are specified in Configuration at line 91.

Separators are then added to the top of each textbox item as well as to each Column type for vertical separators at Line 19, 23, 33, 41, 48, 54, 63, 71, 80, 89, 97 and 106 in the Editor.

"separator": {

"lineThickness": 1,

"lineColor": "#9b9999",

"padding": 25,

"spacing": 40

},

PADDING

To eliminate item padding to generate continuous separator lines, padding is set to -1 in line 89 in Configuration.

DYNAMIC COLUMN WIDTH

Each column’s width is specified to 25% of the ColumnSet at Lines 17, 42, 64 and 90.

"width": "25%",

Limitations

DASHBOARD RENDER ITEM LIMIT 

Regardless of font size, 100 sets of items will render on the dashboard (items sets, not rows). Everything still exports to CSV.

PDF EXPORT LIMITATION

However man rows can fit on a single page (depends on font size), that's what will show in the preview. Any overflow is not thrown a subsequent page and is dropped from the PDF.