Alek_qbeeq
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: 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.io5.4KViews1like1CommentRe: 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.io2.6KViews3likes1CommentRe: 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.io2.3KViews4likes2CommentsRe: 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.io2.5KViews2likes0CommentsRe: 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.io1.8KViews4likes0CommentsRe: 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 QBeeQ7.2KViews6likes1CommentRe: 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 Partner7.2KViews5likes3CommentsRe: 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.pl2.9KViews0likes0CommentsRe: 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).5.1KViews4likes0Comments