cancel
Showing results for 
Search instead for 
Did you mean: 

JTD - BLOX: script to include and exclude filters

Srav_Sense
9 - Travel Pro
9 - Travel Pro

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

4 REPLIES 4

Srav_Sense
9 - Travel Pro
9 - Travel Pro

 

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
9 - Travel Pro
9 - Travel Pro

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
7 - Data Storage
7 - Data Storage

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