How to have dashboard filters affect a formula filer?
Hi DRay , I have this formula in Sisense Bar Chart: (((([Total CLAIM_CNT]) )/([Total CLAIM_CNT],Prev([@Months in DATE], 12),([@Network Name])))-1) Where I have the Category being Network Name, I also have the Network Name in the Dashboard filter but when I select a Network Name in the Dashboard filter the widget does not filter for my selected Network Name. The Network Name being in the Denominator is to get the Total Claim Count. I also know that the hierarchy for filtering in Sisense is Formula Filter > Widget fitler > then Dashboard filter. Is there anyway to override this behavior? I still need to the overall claim counts to get the percentage by individual network names but still want to filter for the specific network name.17Views0likes2CommentsJavaScript 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) }) ; });129Views0likes8Comments