harikm007
Data Warehouse
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Help with BloX Widget
Thank you DRay for tagging me; this is an interesting use case. JBuck2287 Just to confirm if I understand the requirement, you want to show or hide a blox widget that has some message based on Yes/No filter? Please check this post if that helps: https://www.binextlevel.com/post/hide-widgets-based-on-selected-filters Let me know if you are looking for something else Thanks, HariRe: Enhance Your Sisense Dashboard with a Search Box for Filters
Hi MikeGre , It seems like the 'initialized' event is not working. Please try the below query. The main change I made is replacing 'initialized' with 'widgetrefreshed' dashboard.on('widgetrefreshed', function (se, ev) { $('.filters-headline').css({'height':'50%', }); $('.filters-global-header').css('height', '65px'); let searchBox = $('#custom-filter-search'); if(searchBox.length > 0) { return; } let $input = $('<input type="text" id="custom-filter-search">'); let $button = $('<button id="custom-filter-search-button"> Search </button>'); $('.filters-global-header').append($input); $('.filters-global-header').append($button); $button.css({ 'margin-left': '5px', 'padding': '1px 3px', 'border-radius': '3px', 'border': '1.5px solid #bfbfbf', 'background-color': '#ffffff', 'font-size': '13px', 'color': 'black' }) $button.on('click', function(){ const inputValue = $('#custom-filter-search').val().toUpperCase(); $('.global-filters .ew-content-host .ew-panel .ew-item-wrapper').each(function(index, element){ if ($(this).find('.f-header-host .ew-i-caption').text().toUpperCase().includes(inputValue)) { $(this).css('display', 'block') } else { $(this).css('display', 'none') } }) }); }) -HariRe: JavaScript does not work for Tabber
Hi rholmesminton , I tried the above script, and it's working well. One thing to note: make sure your tab names are correct and that the tab names in the 'tabFilterMapping' variable are in uppercase. This is important because the tabber displayed all tab names in uppercase. Here is the updated script: widget.on('ready', function(w, args){ $('.listDefaultCSS .listItemDefaultCSS', element).on('click', function(s){ widget.scriptConfig = true; filter = prism.activeDashboard.filters.$$items.find(el=>el.jaql.title == 'Checklist Type') //Title of filter //mapping of Tab name and filter item. Here when Tab1 is selected, 'Onboarding' will get selected in Checklists Type filter var tabFilterMapping = { 'TAB 1':"Onboarding", 'TAB 2':"Advancement" } var filterValue = tabFilterMapping[$(s)[0].currentTarget.innerHTML] filter.jaql.filter = { "explicit": true, "multiSelection": false, "members": [ filterValue ] } var filterOptions = { save: true, refresh: true, } prism.activeDashboard.filters.update(filter, filterOptions) }) ; }); - HariEnhance Your Sisense Dashboard with a Search Box for Filters
Navigating filters in Sisense dashboards can be cumbersome for users. To improve user experience, implementing a search box allows for quick access to specific filters, eliminating the need for extensive scrolling. This article provides a straightforward script to integrate a search feature into your dashboard, enhancing functionality and usability. The script includes creating a customizable search input and button, which filters visible items based on user input.Re: Gradient color in bar chart based on start/end text of value title
The script needs to be adjusted slightly if the Categories or Breakby fields are not present. Here's the updated version. widget.on('processresult', function(se,ev){ var colorMapping = { 'Level A': 'red', 'Level B': 'green', 'Level C': 'blue', 'Level D': 'yellow' } $.each(ev.result.series, function(seriesIndex, seriesValue){ const seriesName = seriesValue.name; first_part = seriesName.includes('-') ? seriesName.split('-')[0].trim() : seriesName; second_part = seriesName.includes('-') ? seriesName.split('-')[1].trim() : seriesName; $.each(seriesValue.data, function(index, value){ value.color = { linearGradient: { x1: 0, y1: 0, x2: 0, y2: 1 }, stops: [ [0, (first_part in colorMapping ? colorMapping[first_part] : 'gray')], [1, (second_part in colorMapping ? colorMapping[second_part] : 'gray')] ] } }) }) }) -HariRe: Gradient color in bar chart based on start/end text of value title
Hi wallingfordce , Please try the below script and let me know if you are looking for something like this: widget.on('processresult', function(se,ev){ var colorMapping = { 'Level A': 'red', 'Level B': 'green', 'Level C': 'blue', 'Level D': 'yellow' } $.each(ev.result.series, function(seriesIndex, seriesValue){ $.each(seriesValue.data, function(index, value){ const categoryName = value.selectionData[0]; first_part = categoryName.includes('-') ? categoryName.split('-')[0].trim() : categoryName; second_part = categoryName.includes('-') ? categoryName.split('-')[1].trim() : categoryName; value.color = { linearGradient: { x1: 0, y1: 0, x2: 0, y2: 1 }, stops: [ [0, (first_part in colorMapping ? colorMapping[first_part] : 'gray')], [1, (second_part in colorMapping ? colorMapping[second_part] : 'gray')] ] } }) }) }) - Hari
