Supermetrics Support Forum

Solved

Can Supermetrics replace "null" values with 0?

It would be helpful if Supermetrics could replace null metric values with 0 across all Data Studio Connectors.  I believe this would fix various technical and aesthetic issues.  


Is this something that can be done?

  • Thank you for the feedback! I don't know if this is possible within our connectors at this time but I will certainly pass that along to the development team.


    For now though, you can do this through custom fields in the data source to convert nulls to 0.


    Click Resource->Manage added data sources. Click Edit next to the one you want to modify.

    At the top of the field list, click the blue '+' to add a new calculated field.

    image


    Give the new field a name and construct a function like the following, where yourfield is the field name you want to apply this to:

    CASE WHEN yourfield IS NULL THEN 0 ELSE yourfield END


    For example, I did that here with 'Website Registration completed conversion value' as it was coming up null in my report:

    image


    Then you can insert that field in your report instead of the default one and get those 0 values instead of nulls.


    I hope this is helpful, even if it does require some manual setup.


    -Thank you

    Supermetrics Team





  • This worked btw, thank you.  Once you replace null values with 0, you can create custom calculated metrics too.  When metric fields contain null values, they do not work properly when creating new, calculated fields. 

Login to post a comment