ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Card View Customization Does anyone have the code to apply this corner radius to all widgets at once? Re: Custom Colour Palette using Dashboard Script I have one more "problem", The colour palette is working fine, however when I output to PDF, the visual before downloading is the new forced colour palette, but once actually downloaded it uses the colour palette we are trying to override. Is the only way around this to go into every widget and force the colours from the new palette? Re: Custom Colour Palette using Dashboard Script I did eventually get this working, I had some other JS that was causing it to break, thank you so much! Re: Custom Colour Palette using Dashboard Script Thanks for this! I can see that its trying to work, but its likely our version of Sisense is either not compatible or our devs have disabled overriding the colour palette in some way. Re: How to hide a column in a table widget? widget.on('domready', function(se, ev){ // Specify the column indices to hide let columnIndices = [1, 3, 5]; // Function to hide columns function hideColumns() { columnIndices.forEach(function(columnIndex) { $(`table tr > *:nth-child(${columnIndex})`, element).css('display', 'none'); }); } // Initial hiding of columns hideColumns(); // Observe changes in the table body const elementToObserve = $('table tbody', element)[0]; const observer = new MutationObserver(function(e) { for(const m of e) { if (m.type === 'childList') { $.each(m.addedNodes, function(index, value){ // Hide columns in added rows columnIndices.forEach(function(columnIndex) { $(value).find(`td:nth-child(${columnIndex})`).css('display', 'none'); }); }); } } }); observer.observe(elementToObserve, {subtree: true, childList: true}); }); Re: Custom Colour Palette using Dashboard Script Hi, Thanks for this, however it didnt seem to work, all I did was add some random extra colours to the palette list. dashboard.on('initialized', (d, args) => { d.style.$$palette.colors = ['#00F6FF', '#CB9340','#0A223E','#E8F2FB','#2D5B70','#9A9A9A'] // your palette here }); Custom Colour Palette using Dashboard Script I want to be able to override the dashboard palette with my own set of colours, without building a custom set that i can just pick from the option at the top of the dashboard. SolvedExpand Widget to full size as viewer We are running version: 20.21.6.10052 However we seem to be missing a very vital function of expanding the widgets to full size, is this a plugin I need to get our admins to switch on or is it a limitation of our version? RPAVG & RPSUM - One not working without the other in Pivot I Have the following measure that i'm trying to get to work. RPAVG( (((([# of unique EntityReference],[DangerousOccuranceType_id])) +( ([# of unique Level1]) - ([# of unique Level1]))) *200000) / ( ([Employee Hours]) + ([Agency Hours]) + ([Contractor Hours]) +([Overtime Hours]) ),12) I'm doing something a little funny with [# of unique level] because it seems to break if we have had zero [#of unique entityreference] so this is to just get around that issue. However my RPAVG wont work unless I either somehow put RPSUM into the equation, or have another column using RPSUM within my pivot. The current calc I have gives me the correct output but only when I have the second column where im doing rpsum / 12. If I remove the rpsum / 12 column, It looks like this: If I do just a basic RPAVG no funny business, this is the view I get: RPAVG( (([# of unique EntityReference],[DangerousOccuranceType_id]) *200000) / ( ([Employee Hours]) + ([Agency Hours]) + ([Contractor Hours]) +([Overtime Hours]) ) *1,12) In this scenario, If I switch back on rpsum / 12, it gives me the correct output again. I guess that I need help understanding if I'm using rpavg correctly, and If I am, why am I getting these different results. Any help would be greatly appreciated. Blox - Search multiple filters at once I have the following code, but it is only searching on the second filter and not the first. { "style": "", "script": "", "title": "", "titleStyle": [ { "backgroundColor": "#093e52", "backgroundImage": "", "fontColor": "#093e52" } ], "showCarousel": true, "carouselAnimation": { "showButtons": false }, "body": [ { "type": "Container", "style": { "backgroundImage": "", "padding": "5px" }, "items": [ { "spacing": "default", "type": "TextBlock", "horizontalAlignment": "center", "size": "medium", "weight": "bold", "text": "Search Person Name", "color": "" }, { "spacing": "default", "type": "TextBlock", "horizontalAlignment": "center", "size": "supersmall", "weight": "bold", "text": "This filter will show Persons matching the names searched", "color": "" }, { "spacing": "", "type": "Input.Text", "id": "data.filters[0].filterJaql.contains", "placeholder": "Type in the search phrase here", "style": { "margin-top": 5, "text-align": "center", "margin-bottom": -40 } } ] } ], "actions": [ { "type": "Filters", "title": "Search", "data": { "filters": [ { "filterName": "Person Name (DSE)", "filterJaql": { "contains": "" } }, { "filterName": "Person Name (Training)", "filterJaql": { "contains": "" } } ] }, "style": { "color": "#0B0B0B", "backgroundColor": "#DEE0E2" } }, { "type": "Filters", "title": "Reset the Filter", "data": { "filters": [ { "filterName": "Person Name (Training)", "filterJaql": { "explicit": false, "multiSelection": true, "all": true }, "style": { "backgroundColor": "#08445E" } }, { "filterName": "Person Name (DSE)", "filterJaql": { "explicit": false, "multiSelection": true, "all": true }, "style": { "backgroundColor": "#08445E" } } ] }, "style": { "color": "#0B0B0B", "backgroundColor": "#DEE0E2" } } ] } I want it to search both filters for the same value but I get the following: Any ideas would be greatly welcomed.