Dashboard filter limits the list selection
I have a dashboard filter that is used to select specific annual reporting periods. For example: 2025-2026 The field should include all the reporting periods for each data model. Meaning if a data model has reporting periods that range from 2022 to 2026, the selection list should include: 2022 - 2023 2023 - 2024 2024 - 2025 2025 - 2026 However, for one particular field, the listing does not include anything earlier than 2024 - 2025 (See screen capture) However, if I select Include all...My results in the dashboard widget will include data from all 4 report periods. Any suggestions as to why this is happening?23Views0likes0CommentsHow 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.Solved178Views0likes6CommentsJavaScript 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) }) ; });202Views0likes8Comments