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

user023694

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.

 

GrantSmith

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?

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

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.