Remapping nulls in Analyzer

Options
Victoria_G1
Victoria_G1 Member
in Beast Mode

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)

image.png

Many thanks for the help!

Best Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓
    Options

    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 Coach
    edited December 2023 Answer ✓
    Options

    @Victoria_G1

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

    Let me know if that makes sense!

    Circle.png

    John Le

    You're only one dashboard away.

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

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓
    Options

    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 Coach
    edited December 2023 Answer ✓
    Options

    @Victoria_G1

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

    Let me know if that makes sense!

    Circle.png

    John Le

    You're only one dashboard away.

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

Categories