ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Vertical Grey Dividers Hi KHConsult , Please add the script in dashboard editor tab. Thanks Sijo Re: Pivot table grand total aggregation not working in line chart Hi zohebakber , Please add date in your formula. Thanks Sijo Re: Hiding the Dashboard Hover Information Hi Michael-Schram , Please try this script dashboard.on('refreshend', function(se, ev){ $('.sisense-dashboard-hover').hide(); }); Thanks Sijo 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 Sijo Re: 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 Sijo Re: 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 Sijo Re: nulls to 0 in pivot Hi zach_myt , This script for Linux region widget.transformPivot( { type: ['value'] }, function setCellBackground(metadata, cell) { if(cell.content.trim() == '') cell.content = '0' } ) Thanks Sijo Re: Jump To Dashboard Exclude multiples filter syntax Hi psdutton315 , This script is used for windows region prism.jumpToDashboard(widget, { excludeFilterDims : "[country.Country],[brand.Brand]"}); Pls try this script Thanks Sijo Re: 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 Sijo Re: Tabber Alignnment Issue Hi smadda , Pls Send the screenshot. Thanks Sijo