JTD - BLOX: script to include and exclude filters

[Srav_Sense]

Hi, 

We are using JTD from blox pivot, in which we want the JTD to use different filters. Currently it is defaulted to the dashboard filters. 

I am using include and exclude dim filters, but it is not working right. Can someone please help with what I am doing wrong? Here is the script I am using:

"actions": [

{

"type": "JTD",

"title": "Phone",

"data": {

"dashboardId": "XXX",

"args": {

"displayDashboardsPane": false,

"displayFilterPane": true,

"excludeFilterDims": "[TableName.ColumnName]"

}}} ]

[Srav_Sense]

Below post is helpful to include the filters. "PanelstoExclude" is not working though

Jump To Dashboard Filter | Sisense

[Harry · Accepted solution]

Hello @Srav_Sense ,

Try adding dimensions in excludeFilterDims and includeFilterDims as array.

For example: 

"excludeFilterDims": [
"[TableName.ColumnName1]",
"[TableName.ColumnName2]"
],
"includeFilterDims": [
"[TableName.ColumnName3]",
"[TableName.ColumnName4]"
]

Please let me know if you have any questions

Always here to help,
Harry from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner
www.qbeeq.pl

[Srav_Sense]

Yay! Thank you so much @Harry 

I thought I tried that way before but for some reason it didn't work. Oh well...all good now 🙂

[fourkitessup]

Hi Team,

"excludeFilterDims": [ "[TableName.ColumnName1]", "[TableName.ColumnName2]" ]

 This is not working for date field, can you give any other option to exclude date field as well. 

Regards, Premkumar S