rvickersevotix
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
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?2.4KViews0likes0CommentsRe: 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}); });3.4KViews0likes0CommentsRe: 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 });2.6KViews0likes5CommentsRPAVG & 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.