cancel
Showing results for 
Search instead for 
Did you mean: 

JTD - BLOX: script to include and exclude filters

Srav_Sense
8 - Cloud Apps
8 - Cloud Apps

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]"
}}} ]

 

1 ACCEPTED SOLUTION

Harry
9 - Travel Pro
9 - Travel Pro

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

QBeeQ - Gold Implementation and Development Partner
www.qbeeq.pl

View solution in original post

3 REPLIES 3

Srav_Sense
8 - Cloud Apps
8 - Cloud Apps

 

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

Jump To Dashboard Filter | Sisense

Harry
9 - Travel Pro
9 - Travel Pro

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

QBeeQ - Gold Implementation and Development Partner
www.qbeeq.pl

Srav_Sense
8 - Cloud Apps
8 - Cloud Apps

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 🙂