Sijo1995
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Auto-resetting the dashboard filters
Hi pramod , Dashboard script window.resetFilters = function(d) { //Function to reset the dashboard filters to the default filters. var filters = d.filters; for (var i = 0; i < filters.length; i++) { filters[i].value = filters[i].default; } }; d.on('initialized', function(se, ev) { //Reset the filters when the dashboard is initialized. resetFilters(d); }); Thanks Sijo1.3KViews0likes0CommentsRe: center align all widgets in dashboard
Hi gyanianand , Please try this script dashboard.on('widgetready', function (se, ev) { // Get all the widgets in the dashboard var widgets = dashboard.getWidgets(); // Loop through all the widgets for (var i = 0; i < widgets.length; i++) { // Center align the widget widgets[i].setAlignment('Center'); } }); Thanks Sijo1.4KViews1like0CommentsRe: Replacin 'NULL' with '0' in in calculations for column chart and pivot table
Hi frankmol , https://community.sisense.com/t5/build-analytics/nulls-to-0-in-pivot/td-p/14777 Please try this script function replaceNullsWithZeros(data) { for (var i = 0; i < data.length; i++) { for (var j = 0; j < data[i].length; j++) { if (data[i][j] === null) { data[i][j] = 0; } } } return data; } // Replace all NULL values in the pivot table with 0 widget.on('processresult', function(sender, ev) { ev.result = replaceNullsWithZeros(ev.result); }); And please read this document-https://community.sisense.com/t5/build-analytics/nulls-to-0-in-pivot/td-p/14777 Thanks Sijo4KViews0likes0CommentsRe: Changing fontsize in pivot2 breaks PDF-export
Hi HamzaJ , Please try this script widget.transformPivot({ type: ['member','value'] }, (metadata, cell) => { const { columns, rows } = metadata; const isRowHeader = rows && rows.some(row => row.title === cell.content); // is header if (isRowHeader || columns && !rows) { cell.style = { fontWeight: 'bold', color: '#132f57', backgroundColor: '#e2e9ec', textAlign: 'center', whiteSpace: 'normal' } // is row } else { cell.style = { fontWeight: 'bold', color: '#132f57' } } //cell.style.whiteSpace= 'normal' }); Thanks Sijo1.5KViews1like0Comments