Forum Discussion

zach_myt's avatar
zach_myt
Data Pipeline
05-30-2023
Solved

nulls to 0 in pivot

I am trying to get nulls in a pivot to show as 0's, which seems like it should be very basic built in functionality. I have tried If's, case's, and jquery scripts and nothing seems to work. I can do ...
Information Technology Analytics
Sijo1995's avatar
Sijo1995
Cloud Apps
06-01-2023

Hi zach_myt ,

This script for Linux region

widget.transformPivot(
    {
        type: ['value']
    },
    function setCellBackground(metadata, cell) {
        if(cell.content.trim() == '')
			cell.content = '0'
    }
)

 

Thanks

Sijo