Display Active Filters in Sisense

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:

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

2. Add below Blox script in the design panel

<span class=""><span>{
    "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": []
}</span></span>

3. Add below widget script

<span class=""><span>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
});</span></span>

4. Save the script and refresh the widget.

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

-Hari

Hari KM

Posted 1 year ago

0 comments