Pivot - JTD - Enable JTD for specific row

[Pushpanjali_J]

After using the following property in customize JTD widget script for Pivot widget, JTD is enabled for all rows. 

drillToDashboardNavigateTypePivot: 1

It would be great if we have an option of enabling JTD for specific rows. 

For example, we are having 4 rows and 2 value columns in the pivot but want to have JTD linked to only "row2" and have that "row2" data passing to JTD as filter (as shown in the picture).

NOTE: Customize JTD widget script referenced from Official Sisense documentation: https://www.sisense.com/marketplace/jump-to-dashboard/ 

[AssafHanina]

hey @Pushpanjali_J ,

I'm not able to see a screenshot but it's sounds like you have a Pivot table with 4 Dimensions(Rows) and 2 Measures, and the need is to be able to drill from a Measure but only include 1 or partial Dimension as a Filter in the drill dashboard

Here as Example

The following is achievable using a Widget Script. Please review the following Community article
The Script Exclude the selected filters from the Drill Dashboard. 

prism.jumpToDashboard(widget, {
    excludeFilterDims: ["[DimProducts.Color]","[DimCountries.Region]","[DimCountries.CountryName]"] //update the list according to the filters in a format of table_name.column_name
});

Drill include Widget Script - only Color filter applied

Drill without the Widget Script - all rows applied

Best Regards

[Pushpanjali_J]

Hello @AssafHanina 

I have edited the post attaching the screenshot, please give a look.

The issue is not about passing filters to the JTD. It is about the linking JTD to a specific dimension (rows).

After using drillToDashboardNavigateTypePivot: 1, when we right click on any dimensions (rows), we are seeing the pop-up to drill to JTD as shown in the images.

But I don't want to see that pop up on all the dimensions.

Want to get the JTD drilling ability to only row2 and further only this row's value should pass as filter.

Thanks & Regards

[AssafHanina]

hey @Pushpanjali_J ,

thanks for providing the detailed screenshots. 

it's seems that you would like to disable the option to Drill from the first Category (row1), which might be possible using a widget script. 

The info will be shared with the product house.

Best Regards