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...
Blox
Sijo1995's avatar
Sijo1995
Cloud Apps
11-29-2022

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