Forum Discussion

Priyanka's avatar
Priyanka
Data Storage
08-11-2022

Tabber selected filters

Hi,

I have two tabbers for two different teams for eg: Sales and Marketing to view their respective metrics on their respective tabbers. I also have a filter name called 'Manager' to filter those who head each of these team. I want to default one manager (ex: Jack) to Sales tabber and another manager (ex: Jill) to Marketing tabber. 


Also, how can I default various filters on these tabs?

4 Replies

Replies have been turned off for this discussion
    • harikm007's avatar
      harikm007
      Data Warehouse

      Hi Priyanka , 

      If you are using WidgetsTabber plugin, try this script (add this script to tabber widget and replace text as per the comment in script):

       

      
      widget.on('ready',function(w, e) { 	
      	
      	$('.listDefaultCSS .listItemDefaultCSS', element).on('click', function(s){ 
      		
      		filter = prism.activeDashboard.filters.$$items.find(el=>el.jaql.title == 'Region') //Replace 'Region' with title of filter
      	
      		//mapping of Tab name and filter item. Here when Tab1 is selected, 'South' will get selected in Region filter
      		var tabFilterMapping = {
      			'Tab1':"South",
      			'Tab2':"Northeast"
      		}
      		
      		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)
      	}) 
      })

       

       -Hari

      • hvibberts's avatar
        hvibberts
        Cloud Apps

        Hi @harikm007 

        What if I wanted to do multiple items for the filter.... so for tab1 I want the filter (seller country) to equal US, for Tab2 I want the filter (seller country) to equal everything but US.