Reports - show null values as zero in report

Hi Markus

Unfortunately, reporting on a lack of data is typically something that needs to be handled in Data Designer 😓

Here's a Community post you can use as a guide for how to approach this: 

Seconding ​@romihache that a Data Design might be your best bet here… but maybe if you could share more information on the exact build, we could better assist. Are you already using a number field that lives on an object, where the number field has a value for some customers and is NULL for others? Or are the NULL values you’re referring to another data type? 🤔

If you’re reporting on an object in Gainsight CS, and the field you’re trying to report on is a number field, you could consider setting a default value in the field to “0” in Data Management, and then using a one-time rule to backfill the 0 value to the same field for all existing Companies with a NULL value. Setting a default value in DM doesn’t automatically populate the same on existing records, so the OTR is crucial 👌 

If you’re using some kind of aggregated value directly in report builder for gauge visuals, then Romi is totally right - DD is the way to go!