cancel
Showing results for 
Search instead for 
Did you mean: 

Jump To Dashboard Exclude multiples filter syntax

psdutton315
7 - Data Storage
7 - Data Storage

Would like to exclude multiple columns in a pivot table as filters in a jump to dashboard. We are using the syntax below in a widget script on the dashboard that we are jumping from, but there is an issue and the filters are not being excluded. We built the script based on feedback in another post:

https://community.sisense.com/t5/build-analytics/is-there-a-way-to-pass-specific-filters-for-jump-to...

Here is the script we are using:

 

prism.jumpToDashboard(widget, { 
displayDashboardsPane:false, 
displayToolbarRow :false, 
displayHeaderRow :false,
excludeFilterDims: [
"[_drill_CSNAP_LOAD_DETAIL.CUST_CODE]", 
"[_drill_CSNAP_LOAD_DETAIL.Days In PICKUP_DATE (Calendar)]",
"[_drill_CSNAP_LOAD_DETAIL.Origin City State]",
"[_drill_CSNAP_LOAD_DETAIL.Destination City State]",
"[_drill_CSNAP_LOAD_DETAIL.CARRIER_MODE]",
"[_drill_CSNAP_LOAD_DETAIL.CARRIER_SERVICE]"
  ],
includeFilterDims: [
"[_drill_CSNAP_LOAD_DETAIL.LOAD_NBR]"
]
 });
 
but it doesn't seem to be working.
Any advice would be appreciated
Thanks!

2 REPLIES 2

psdutton315
7 - Data Storage
7 - Data Storage

nvm - figured it out
Sure wish there was better documentation and/or examples

 

Sijo1995
9 - Travel Pro
9 - Travel Pro

Hi @psdutton315 ,

This script is used for windows region

prism.jumpToDashboard(widget, { excludeFilterDims   
: "[country.Country],[brand.Brand]"});

Pls try this script

Thanks

Sijo