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
    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

zach_myt's avatar
zach_myt
Data Pipeline
06-01-2023

Simple and it works correctly, thank you!