cancel
Showing results for 
Search instead for 
Did you mean: 

How to avoid duplicate rows in BLOX pivot

Srav_Sense
8 - Cloud Apps
8 - Cloud Apps

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!

4 REPLIES 4

Sijo1995
7 - Data Storage
7 - Data Storage

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
8 - Cloud Apps
8 - Cloud Apps

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
8 - Cloud Apps
8 - Cloud Apps

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

Sijo1995
7 - Data Storage
7 - Data Storage

Hi @Srav_Sense ,

Please try Rank() function to remove duplicate value.

Thanks

Sijo