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.
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?
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.
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.