Forum Discussion

Srav_Sense's avatar
Srav_Sense
Cloud Apps
11-21-2022

How to avoid duplicate rows in BLOX pivot

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

Replies have been turned off for this discussion
  • 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