rholmesminton
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: Drill To Buttons
I tried to modify the above code but, it didn't work. //Define the drilling options' title in a list of constants like shown below const drillOption1Title = 'Section Type ' const drillOption2Title = 'Program Name' //Define the drilling options' JAQL in a list of constants like shown below const drillOption1JAQL = { "table": "Personnel - Board Certifications", "column": "Board Certifications - Section Type", "dim": "[Personnel - Board Certifications.Board Certifications - Section Type]", "datatype": "text", "merged": true, "title": "Section Type" } const drillOption2JAQL = { "table": "Personnel - Board Certifications", "column": "Board Certifications - Program Name", "dim": "[Personnel - Board Certifications.Board Certifications - Program Name]", "datatype": "text", "merged": true, "title": "Program Name" } //Set margin for the buttons widget.on('processresult', function(se, ev){ ev.result.chart.marginTop = 90; }); var selectedDrillOption = 'None'; widget.on("domready", function(w, args){ chart = w.chart[0][Object.keys(w.chart[0])[0]].hc; chart.renderer.label('Drill into:</br>' + '<b>' + selectedDrillOption + '</b>', 30, 10) .css({ fontSize: '14px' }) .attr({ zIndex : 10, height: 15, width: 50, 'text-align': 'center' }) .add(); chart.renderer.button('None', 120, 10) .attr({ zIndex : 10, height: 15, width: 50, 'text-align': 'center' }) .on('click', function() { selectedDrillOption = 'None'; widget.metadata.panels[0].items[1].disabled = true; widget.refresh(); }) .add(); chart.renderer.button(drillOption1Title, 200, 10) .attr({ zIndex : 10, height: 15, width: 100, 'text-align': 'center' }) .on('click', function() { selectedDrillOption = drillOption1Title; widget.metadata.panels[0].items[1].disabled = false; widget.metadata.panels[0].items[1].jaql = drillOption1JAQL; widget.refresh(); }) .add(); chart.renderer.button(drillOption2Title, 330, 10) .attr({ zIndex : 10, height: 15, width: 100, 'text-align': 'center' }) .on('click', function() { selectedDrillOption = drillOption2Title; widget.metadata.panels[0].items[1].disabled = false; widget.metadata.panels[0].items[1].jaql = drillOption2JAQL; widget.refresh(); }) .add(); });0Views0likes0Comments- 27Views0likes0Comments
JavaScript does not work for Tabber
I added the following JavaScript to my tabber widget. However it does not execute. I found this JavaScript in a help article on the Sisense Community website. It is designed to change the dashboard filters based on which tab is selected. Can you please tell me what I need to do make this script work? My work around was to hide the dashboard filter and disabling the dashboard filter on each widget and creating a widget level filter. $('.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 = { 'Tab1':"Onboarding", 'Tab2':"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) }) ; });