Forum Discussion

psdutton315's avatar
psdutton315
Data Storage
05-30-2023

Jump To Dashboard Exclude multiples filter syntax

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-dashboard/m-p/4256

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

Replies have been turned off for this discussion
  • nvm - figured it out
    Sure wish there was better documentation and/or examples

     

  • Hi psdutton315 ,

    This script is used for windows region

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

    Pls try this script

    Thanks

    Sijo