Skip to main content

Hello everyone!

I am busy building Gauge reports on how often customers use specific features in our system. We get the data of feature usage from Gainsight PX, and I can show them within a report with no problem.

However, when also showing features that come up as NULL in the period of the report, the entire feature does not show up (since it is NULL).

Is there a way to replace NULL values with zeroes, so that the feature shows up in my report as zero and is thus visible in the Gauge report?

 

Kind regards,

Markus

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! 

Terms & ConditionsCookie settingsAccessibility statement