Beast Mode

Beast Mode

Remove null values to make sorting works accordingly

Hello, I have a "transaction month" column that can't be sorted accordingly because I have some months with NULL values. When I used sorting ascending/descending my months looks like this:

Question, is there a formula that can be used in beastmode or function in domo to correct my sequence by month when I have a NULL values?

Thank you.

Best Answer

  • Answer ✓

    You could correct the nulls by using the following beastmode:

    1. IFNULL(`YourValue`, 0)

    You can also sort any values using a beastmode like this:

    1. CASE
    2. WHEN `Transaction Month` = 'Jan' THEN 1
    3. WHEN `Transaction Month` = 'Feb' THEN 2
    4. WHEN `Transaction Month` = 'Mar' THEN 3
    5. WHEN `Transaction Month` = 'Apr' THEN 4
    6. WHEN `Transaction Month` = 'May' THEN 5
    7. WHEN `Transaction Month` = 'Jun' THEN 6
    8. WHEN `Transaction Month` = 'Jul' THEN 7
    9. WHEN `Transaction Month` = 'Aug' THEN 8
    10. WHEN `Transaction Month` = 'Sep' THEN 9
    11. WHEN `Transaction Month` = 'Oct' THEN 10
    12. WHEN `Transaction Month` = 'Nov' THEN 11
    13. WHEN `Transaction Month` = 'Dec' THEN 12
    14. Else 13
    15. END

    If I solved your problem, please select "yes" above

Answers

  • Answer ✓

    You could correct the nulls by using the following beastmode:

    1. IFNULL(`YourValue`, 0)

    You can also sort any values using a beastmode like this:

    1. CASE
    2. WHEN `Transaction Month` = 'Jan' THEN 1
    3. WHEN `Transaction Month` = 'Feb' THEN 2
    4. WHEN `Transaction Month` = 'Mar' THEN 3
    5. WHEN `Transaction Month` = 'Apr' THEN 4
    6. WHEN `Transaction Month` = 'May' THEN 5
    7. WHEN `Transaction Month` = 'Jun' THEN 6
    8. WHEN `Transaction Month` = 'Jul' THEN 7
    9. WHEN `Transaction Month` = 'Aug' THEN 8
    10. WHEN `Transaction Month` = 'Sep' THEN 9
    11. WHEN `Transaction Month` = 'Oct' THEN 10
    12. WHEN `Transaction Month` = 'Nov' THEN 11
    13. WHEN `Transaction Month` = 'Dec' THEN 12
    14. Else 13
    15. END

    If I solved your problem, please select "yes" above

  • Thanks a lot! :)

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In