Remapping nulls in Analyzer

Hello,

I have a question about the remapping nulls function in Analyzer. Maybe I am not understanding what this function is supposed to do, but basically I am trying to replace all blank cells in a column with another numerical value. However, when I do it through the remapping nulls function, I see no change in the cells (screenshot attached)

Many thanks for the help!

Best Answers

  • MarkSnodgrass
    Answer ✓

    The remap nulls likely isn't working because the data contains blank spaces instead of actually being null.

    I would suggest dealing with this by creating a beast mode in Analyzer that looks like this:

    CASE WHEN LEN(TRIM(fieldname)) >= 1 THEN fieldname ELSE replacementvalue END

    This will trim out all the spaces and then check the length of the field. If it is at least 1 character then use the existing value. Otherwise, use a value you want to replace it with.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • DashboardDude
    DashboardDude Contributor
    edited December 2023 Answer ✓

    @Victoria_G1

    Here are a couple ways to replace that blank: https://www.loom.com/share/c0f06cc207ed4bf187b3e3dd6fcce975

    Let me know if that makes sense!

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

Answers

  • MarkSnodgrass
    Answer ✓

    The remap nulls likely isn't working because the data contains blank spaces instead of actually being null.

    I would suggest dealing with this by creating a beast mode in Analyzer that looks like this:

    CASE WHEN LEN(TRIM(fieldname)) >= 1 THEN fieldname ELSE replacementvalue END

    This will trim out all the spaces and then check the length of the field. If it is at least 1 character then use the existing value. Otherwise, use a value you want to replace it with.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • DashboardDude
    DashboardDude Contributor
    edited December 2023 Answer ✓

    @Victoria_G1

    Here are a couple ways to replace that blank: https://www.loom.com/share/c0f06cc207ed4bf187b3e3dd6fcce975

    Let me know if that makes sense!

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry