How to avoid duplicate rows in BLOX pivot

[Srav_Sense]

Hello, 

We have a BLOX pivot from which there are multiple JTDs, from different columns. But the issue is that we are getting duplicate rows due to the different columns we are using. We are unable to hide certain columns since those are being passed as filters to JTDs.

Is there a way to avoid this issue? 

Thank you!

[Sijo1995]

Hi @Srav_Sense ,

Please try this script

            "data": {
                "dashboardId": " ",
                "args": {
                    "displayDashboardsPane": true,
                    "displayFilterPane": true,
                    "mergeTargetDashboardFilters": true,
                    "resetDashFilterAfterJTD": true,
                    "drilledDashboardDisplayType": 3,
                    "excludeFilterDims": [
                        "[Bands.employee_status]"
                    ]
                }
            }

Thanks

Sijo

[Srav_Sense]

Hi @Sijo1995 ,

Thank you so much for your reply. The JTD looks okay but the data in the main table (BLOX pivot) has duplicate values.

I am using the code from here for BLOX pivot - BLOX WIDGET: PIVOT INSIDE A PIVOT - Sisense Community

Thank you!

[Srav_Sense]

@Sijo1995 Just wanted to say, we would like to display distinct rows on the main pivot table. 

[Sijo1995]

Hi @Srav_Sense ,

Please try Rank() function to remove duplicate value.

Thanks

Sijo