Display Active Filters in Sisense

[harikm007]

If you find it challenging to locate which filters are currently applied in your Sisense dashboard due to a high number of options, you're not alone. Scrolling through the filter panel can be cumbersome. A great solution is to add a widget that displays the titles of the active filter panels, making it easier to track your selections. You can achieve this with Blox and a bit of scripting, simplifying your dashboard navigation and enhancing your data experience.

Steps:

1. Create a blox widget and a measure with formula "0" and name it "values"

   

   2. Add below Blox script in the design panel

   {
       "style": ".blox-slides:first-child .filter-summary-title{display:block !important;} .blox-slides .filter-summary-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}",
       "script": "",
       "title": "",
       "showCarousel": false,
       "body": [
           {
               "type": "TextBlock",
               "text": "Applied Filter Dimensions",
               "class": "filter-summary-title",
               "style": {
                   "text-align": "left",
                   "font-size": "16px",
                   "margin": "5px",
                   "text-wrap": "wrap",
                   "color": "black",
                   "font-weight": "600",
                   "display": "none"
               }
           },
           {
               "type": "Container",
               "items": [
                   {
                       "type": "ColumnSet",
                       "columns": [
                           {
                               "type": "Column",
                               "width": "100%",
                               "style": {
                                   "flex-direction": "row"
                               },
                               "items": [
                                   {
                                       "type": "TextBlock",
                                       "text": "{panel:value}️",
                                       "style": {
                                           "text-align": "left",
                                           "font-size": "12px",
                                           "margin": "5px",
                                           "text-wrap": "wrap",
                                           "color": "#ffffff",
                                           "font-weight": "600",
                                           "padding": "2px 5px",
                                           "border-radius": "5px",
                                           "background-color": "#b04343"
                                       }
                                   }
                               ]
                           }
                       ]
                   }
               ]
           }
       ],
       "actions": []
   }

   3. Add below widget script

widget.on('processresult', function(se, ev){
	dashfilters = ev.widget.dashboard.filters.flatten();
	let resultArr = []
	dashfilters.forEach((item, index) => {
		
		if (!item.jaql.filter.all) {
			resultArr.push(
				{

					'0': {
						"Panel": "value",
						"Value": item.jaql.title,
						"Text": item.jaql.title,
						"HasValue": true

					}
				}
			);
		}
	})

	ev.result = resultArr
});

4. Save the script and refresh the widget.

For more information, refer https://www.binextlevel.com/post/display-active-filters-in-sisense 

-Hari