How to remove the week that is become zero when I drill path from month to weeks?

user023694
user023694 ⚪️
in Card Building

I am new in DOMO, I am trying to remove the Week 18 in my card when I drill path from Month of May to Weeks.

 

Either I remove it or just give me the week 18 data which it show when I select the Month of April.

 

Remove Week 18.jpg

Comments

  • GrantSmith
    GrantSmith Indiana 🥷

    Hi @user023694 

     

    Have you tried using a Beast Mode to set a value when your data is null and then use that Beast Mode in a filter to ignore those null values in your chart?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • user023694
    user023694 ⚪️

    The week 18 have data its just not showing in Month of May.

    but if you go to Month of April the week 18 have data then week 14 is not show data because its part of month of March.

     

    how to ignore data using beast mode? my beast mode is ifnull then 0.

     

    Thank you very much.

  • GrantSmith
    GrantSmith Indiana 🥷

    Drag your beast mode to the filter section of the card and then select "is not" and set 0 as the value and click apply.

     

    Screen Shot 2020-06-16 at 3.15.52 PM.png

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
This discussion has been closed.

Categories