Can I remove a predefined filter in Sisense

Question

Am I able to remove a predefined filter within Sisense that would disallow my viewers from choosing this option? I am using a date filter and the options in the date filter are Last, This, and Next. I want to be able to remove the Last but keep the This and Next filters as options for my viewers.

DRay intapiuser

RAPID BI Support · Accepted Answer

Hi Astroraf ,

Can you try the following?


        prism.on('dashboardloaded', (args, dash) => {
			const elem = document.createElement('style')
        	elem.innerText = `.gsoNqAmwurDnBIjywenH:nth-child(1) { display: none; }`
            document.head.appendChild(elem)

        })

This removes the 'Last' item by hiding the associated container in CSS.

It works on my side L2024.1 - but would be mindful to check if any changes to the class name in future (should include in any future version upgrade regression testing in case you need to change the reference).

Result:

Thanks,

Daniel

RAPID BI

daniel.ranisavljevic@rapidbi.com.au

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

RAPID BI Support · Answer

Hi Astroraf ,

HaPIPCLdFZZA6Wn8q1VU looks like the class for the divs that contain these controls.

prism.on('dashboardloaded', (args, dash) => {
	const elem = document.createElement('style')
	elem.innerText = `
	.gsoNqAmwurDnBIjywenH:nth-child(1) { 
		display: none; 
	}
	.HaPIPCLdFZZA6Wn8q1VU:nth-child(3) {
		display: none;
	}
	.HaPIPCLdFZZA6Wn8q1VU:nth-child(4) {
		display: none;
	}
	`
	document.head.appendChild(elem)
})

Try this one out and let me know how you go?

Daniel

RAPID BI

daniel.ranisavljevic@rapidbi.com.au

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

Rafael Ferreira · Answer

rapidbisupport Thank you so much for the answer. Can you explain what the code is doing for some of us who aren't as tech-savvy with CSS?

Hamza Jap-Tjong · Answer

Hey Astroraf ,

I dont think this is possible. However you could use Blox to create buttons that do exactly this. You can then lock that filter so users cannot change it, except for with the predefined filters in the Blox buttons. --> https://community.sisense.com/t5/knowledge/blox-filter-buttons-for-trailing-x-months/ta-p/8649

Here is a link to a post explaining this. If you are looking for a easier way then I can recommend Ravid_PaldiTeam 's date range filter https://www.paldi.solutions/plugins/date-range-filter

Hamza