ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Custom color for pivot table header Hey tsaho8 Try this widget script: widget.transformPivot({ rowIndex: ['member'] }, function setCellStyle(metadata, cell) { if(metadata.rowIndex == 0){ cell.style.color = 'black'; cell.style.fontWeight = 'bold'; cell.style.background = 'linear-gradient(0deg, rgba(83,199,251,1) 0%, rgba(243,251,251,1) 100%)'; } }); Always here to help, Alek from QBeeQ aleksander.jonczek@qbeeq.io QBeeQ - Gold Implementation and Development Partner www.qbeeq.io Re: Accessing Color Palette from Script Hey CDavidOrr, You can use this property to get dashboard pallet: prism.activeDashboard.style.options.palette Always here to help, Alek from QBeeQ aleksander.jonczek@qbeeq.io QBeeQ - Gold Implementation and Development Partner www.qbeeq.io Re: Data point limit on scatter map Hi jonhaworth, You can try this widget script: widget.on("buildquery", function(se,args) { args.query.count = 8000; }) Unfortunately, I don't have the data to test it on Scatter Map. Please let me know if it works for you. Always here to help, Alek from QBeeQ aleksander.jonczek@qbeeq.io QBeeQ - Gold Implementation and Development Partner www.qbeeq.io Re: Dropdown Menu Blox Display Issue Hey JoshG In order to show what is selected you need to add two things in blox editor: 1. some class name to dropdown, 'tester' for example, 2. add script which will find filter and set it on dropdown "script": "var found = prism.activeDashboard.filters.$$items.find(element => element.jaql.title == 'YOUR FILTER TITLE'); var filterMember = found.jaql.filter.members[0];$('.tester').val(`${filterMember}`)", Please note, that it has to be in one line. If you're looking for something more advanced, please take a look at QBeeQ Advanced Filter plugin which is by far the best filtering solution available for Sisense. This plugin allows you to create advanced customized filters on the dashboard area itself, with many functional and design options. Always here to help, Alek from QBeeQ aleksander.jonczek@qbeeq.io QBeeQ - Gold Implementation and Development Partner www.qbeeq.io Re: Searchable Input Text That Displays the Value Selected Hey prakashp, If it has to be text input, you can do something like this: { "style": {}, "script": "var found = prism.activeDashboard.filters.$$items.find(element => element.jaql.title == 'Country'); var filterMember = found.jaql.filter.members[0];$('.tester').val(`${filterMember}`)", "title": "", "titleStyle": [ { "display": "none" } ], "showCarousel": true, "carouselAnimation": { "showButtons": false }, "body": [ { "type": "Container" }, { "type": "ColumnSet", "separator": false, "spacing": "default", "columns": [ { "type": "Column", "width": "170px", "items": [] }, { "type": "Column", "spacing": "none", "width": "175px", "items": [ { "type": "Container", "spacing": "none", "width": "150px", "items": [ { "type": "Input.Text", "id": "data.filters[0].filterJaql.members[0]", "class": "tester", "value": "Search Country by Name", "displayType": "compact", "style": { "margin-top": "30px" } } ] } ] }, { "type": "Column", "spacing": "none", "width": "175px", "items": [ { "type": "Container", "spacing": "none", "width": "80px", "items": [ { "type": "ActionSet", "margin": "0px", "padding": "0px", "style": { "margin-top": "30px" }, "actions": [ { "type": "Filters", "title": "Apply", "data": { "filters": [ { "filterName": "Country", "filterJaql": { "explicit": true, "members": [ "" ] } } ] } } ] } ] } ] } ] } ], "actions": [] } Let me know if it fits your requirments. Another more robust option would be to utilize the powerful QBeeQ Advanced Filter plugin which is by far the best filtering solution available for Sisense. This plugin allows you to create advanced customized filters on the dashboard area itself, thus taking better advantaged of dashboard real estate, and allows searching, filter buttons, advanced date range options, custom look and feel and much much more,Please do not hesitate to reach out to see a live demo, or if we can help in any way, we’re always here to help Always here to help, Alek from QBeeQ aleksander.jonczek@qbeeq.io QBeeQ - Gold Implementation and Development Partner www.qbeeq.io Re: How to create custom action based on a BLOX dropdown filter (+Styling the filter)? Hey Iris, You can set global rules for css in the first line of blox: "style": "#select_id { width: 100%; border: 1px solid; border-radius: 15px; padding: 0.25em 0.5em; font-size: 1.25rem; cursor: pointer; background: radial-gradient(circle, rgba(238,174,202,1) 0%, rgba(148,187,233,1) 100%);}", You'll get something like this: Regarding custom action -> How do you pass members to the filter object? You can try this: prism.activeDashboard.filters.update( { 'jaql': { 'dim': "[Brand.Brand]", // filter dim 'title': "Brand", // filter title 'filter': { 'members': [payload.data.select_id] // filterText }, 'explicit': true, 'multiSelection': true, 'datatype': 'text' } }, { 'save': true, 'refresh': true } ) If you are intrested in some more advanced filter dropdown - where you are able to choose single or multiple items in one dropdown, add dependent filter within dropdowns, be able to control look and feel from design panel, I can suggest one of our most popular plugin Advanced dashboard filters Best regards, Alek from QBeeQ Re: How to create custom action based on a BLOX dropdown filter (+Styling the filter)? Hey irismaessen Could you provde full json example of what you are trying to achive? 1. I'm not sure what you are reffering as styling select input but you can always use style parameter in Blox "style": "#select_id { width: 80%; border: 1px solid aqua; etc;}" or { "type": "Input.ChoiceSet", "id": "select_id", "class": "", "displayType": "compact", "choices": "{choices:Brand}", "style": { "color": "coral" } } 2. Within custom action console.log(payload.data.select_id) should return selected value from dropdown. //Instead of console.log(selectVal); //try console.log(filterText) Always here to help, Alek from QBeeQ aleksander.jonczek@qbeeq.pl QBeeQ - Gold Implementation and Development Partner Re: Reading Widget value to Edit script Hi Nazeer, For indicators you can use something like this: widget.on('processresult', function (e, ev) { console.log(ev.result) console.log(e.indicatorInstance) }); First console log will return basic informations like values, title, etc. Second one will return more advance properties, like styling of each element. Now, depending on what you would like to achive, you can use simple if statment and change for example font color of indicator label. widget.on('processresult', function (e, ev) { var options = { title: { fontWeight: 'bold', color: 'green' } } if (ev.result.value.data > x) e.indicatorInstance.setOptions('numericSimple', options); }); Alek aleksander.jonczek@qbeeq.pl Re: Blox submit to zapier is empty Hi adrian_lester Could you check in the browser console if there are any errors? Could you please share a snippet of your code? Are you using any custom action or just the default submit sisense action? Re: Dynamic username on dashboard welcome message cglowe You can also play with blox to get the desired effect. Blox: { "style": "", "script": "", "title": "", "showCarousel": true, "body": [ { "type": "Container", "items": [ { "type": "ColumnSet", "columns": [ { "type": "Column", "width": "50%", "items": [ { "type": "TextBlock", "text": "❤️️ Welcome ️", "style": { "text-align": "center", "font-weight": "bold", "font-size": "24px", "margin-top": "50px", "margin-bottom": "50px", "margin-left": "50%", "text-aligment": "right" } } ] }, { "type": "Column", "width": "30%", "items": [ { "type": "TextBlock", "text": "️test", "id": "myUser", "style": { "text-align": "center", "font-weight": "bold", "font-size": "24px", "margin-top": "50px", "margin-bottom": "50px", "margin-left": "-70%", "color": "blue" } } ] } ] } ] } ], "actions": [] } widget script: widget.on("ready", function (w, args) { $("#myUser").text(prism.user.firstName + ' ' + prism.user.lastName) }) This is just simple example but within column set you can put any TextBlock/data you want (static text, data from elasticube etc).