button to reset all widget-level filters

Thanks. I'm not proposing a button that entirely turns off Widget filters.

Instead, I'm proposing a button that "resets" the widgets to match the Dashboard filters. So it would actually have performance impacts by simplifying filtering complexity as I see it.

The point of this button is to make t-shooting Dashboard behaviors easier for Designers. We find that our users often back themselves into a corner where they've inadvertently (and unnecessarily) created filters at the widget level that should really be at the Dashboard level. Or maybe they were meant to be temporary filters for the purposes of troubleshooting an issue.

Hibminehart ,

As DRay mentioned - not as convenient as having a solution OOTB - but at least a workaround you can try?

You could use a BloX control to do this, with a editor json as follows:

{
    "style": "",
    "script": "",
    "title": "",
    "showCarousel": true,
    "body": [
        {
            "type": "Container",
            "items": [
                {
                    "type": "TextBlock",
                    "text": "<button id='reset_filters_button'> RESET ALL WIDGET FILTERS </button>",
                    "style": {
                        "text-align": "center",
                        "font-weight": "bold",
                        "font-size": "24px",
                        "margin": "100px"
                    }
                }
            ]
        }
    ],
    "actions": []
}

and a dashboard script like this:

dashboard.on('domready', () => {
    $('#reset_filters_button').on('click', () => {
		debugger
        let widgetCount = prism.activeDashboard.widgets.$$widgets.length
		for (let i = 0; i < widgetCount; i++) {
		  let widget = prism.activeDashboard.widgets.$$widgets[i]
		  widget.metadata.panels.find((p) => { return p.name === 'filters' }).items.splice(0,widget.metadata.panels.find((p) => { return p.name === 'filters' }).items.length)
		  widget.metadata.ignore.ids = []
		  widget.changesMade('widget', 'filters')
		  widget.refresh()
		}
    })
})

Let me know how you go?

Thanks,

Daniel

RAPID BI

[email protected]

RAPID BI - Sisense Professional Services | Implementations | Custom Add-ons

Hello bminehart,

Thank you for submitting your idea!

Can you look at this document and let me know if would work for you? I know it's not exactly an easy-to-use UI implementation, but it might be a decent workaround. https://community.sisense.com/t5/knowledge/reset-to-default-filters-button-using-blox/ta-p/786

Hello bminehart,

Thank you for submitting your idea!

Can you look at this document and let me know if would work for you? I know it's not exactly an easy-to-use UI implementation, but it might be a decent workaround. https://community.sisense.com/t5/knowledge/reset-to-default-filters-button-using-blox/ta-p/786

I would like to investigate this further also. There can be major performance impacts from turning off all the filters on all the widgets on the entire Dashboard. Some filters may be hidden from the viewer also, and trying to sync those between the Widget and Dashboard could cause all kinds of issues. 

Another solution you can look at is resetting the filters to default on reload, as mentioned here: https://community.sisense.com/t5/embed-analytics/how-to-reset-to-default-filters-after-refreshing-the-page/m-p/4185

This is planned for a future release!

Hi rapidbisupport ,

I tried your code out, but unfortunately, it didn't work. Does the code still work with the current version of Sisense, or do we need to update the code to reflect the new Sisense version since this was posted?