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?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) }) ; });
