Forum Discussion

hkkwon89's avatar
hkkwon89
Cloud Apps
08-26-2022
Solved

Is there a way to pass specific filters for Jump to Dashboard?

I have a pivot table with a few columns with JTD enable to another dashboard.

However, I want the OldestNoteDateofVisit column to not pass as a filter.

Is it possible to exclude specific column to be passed as a filter in JTD?

dashboards & reporting
  • OleksiiDemianyk's avatar
    OleksiiDemianyk
    09-01-2022

    Hi Sneak,

    It looks like you missed space in the dimension. The correct form is below:

    [NOTES.OldestNoteDateOfVisit (Calendar)]

    Another point - type of the variable "excludeFilterDims" is "array". So, the whole script will look like this:

    prism.jumpToDashboard(widget, {
  excludeFilterDims: [
    "[NOTES.OldestNoteDateOfVisit (Calendar)]"
  ]
}

     

8 Replies

Replies have been turned off for this discussion
  • sneak's avatar
    sneak
    Cloud Apps
    08-29-2022
    Copy LinkReport

    Yes, you’re looking for the excludeFilterDims option, which can be set in the widget script of the source widget. For example:

     

    prism.jumpToDashboard(widget, { excludeFilterDims:"[table_name.column_name]"});

     

    I think the syntax is right, but I can’t actually test right this minute. May need to play around with the quotes and brackets around the table and column name. Let me know if you can’t get it to work and I’ll pull one of the working examples I have.

    There are a lot of other useful options you can set in the source widget script as well, such as hiding certain panes, changing the type of JTD (pop up vs. new tab vs. new window), etc. You can see some of those details here (though the examples aren’t very thorough): https://www.sisense.com/marketplace/jump-to-dashboard/ (under the “Technical Details” tab). 

    Hope this helps! Write back and let us know if the syntax is correct or needs to be adjsuted for the excludeFilterDims option

    • hkkwon89's avatar
      hkkwon89
      Cloud Apps
      08-29-2022
      Copy LinkReport

      Hi sneak ,

      Thanks for your reply. I did try that route as well but it did not work for me.

      I am pasting the script I have below.

       

      prism.jumpToDashboard(widget, {
drilledDashboardDisplayType:1,
displayFilterPane:true,
excludeFilterDims:["[NOTES.OldestNoteDateOfVisit]"],
displayDashboardsPane:false,
displayToolbarRow:false,
displayHeaderRow:false,
drillToDashboardNavigateType:1,
dashboardId:"62fd12cc9162f000395da2cc"
});

      Thank you

      • sneak's avatar
        sneak
        Cloud Apps
        08-29-2022
        Copy LinkReport

        Hi hkkwon89,

        Yeah, I’ve battled with this before as well, like I mentioned. I went to pull a working example, and the problem is with syntax. In this case, since you are only excluding one filter, you don’t need to leading bracket (that’s only for cases where you are going to list multiple dimensions to exclude).

        So, update your script to look like this:

        prism.jumpToDashboard(widget, {
stuff,
excludeFilterDims:"[NOTES.OldestNoteDateOfVisit]",
stuff
});

         and it shold work. No leading brackets before the quotes start after the excludeFilterDims key.

        Let me know.

    • OleksiiDemianyk's avatar
      OleksiiDemianyk
      Sisense Employee
      09-01-2022
      Copy LinkReport

      Hi Sneak,

      It looks like you missed space in the dimension. The correct form is below:

      [NOTES.OldestNoteDateOfVisit (Calendar)]

      Another point - type of the variable "excludeFilterDims" is "array". So, the whole script will look like this:

      prism.jumpToDashboard(widget, {
  excludeFilterDims: [
    "[NOTES.OldestNoteDateOfVisit (Calendar)]"
  ]
}