Forum Discussion
Exclude a data from displaying on a bar chart
I grouped the Intake age for Active intakes using this formula:
Intake Age Grouping = IF(Intakes[Age]>0,
SWITCH(TRUE(),Intakes[Age]<=7, "0day-1 week", Intakes[Age]<=21, "2-3weeks", Intakes[Age]<=31, "<1month-1month", Intakes[Age]<=365, "2months-1Year",Intakes[Age]>365, "more than a Year"))
However, when i put the result into a bar chart, I get the below screen shot, because the blank belongs to resolved intakes. Please how can i exlcude the blank from displaying on the bar chart?
You should be able to apply a filter on the visual within the Intakes[age] field selectn advanced filter options and choose does not equal blank
1 Reply
You should be able to apply a filter on the visual within the Intakes[age] field selectn advanced filter options and choose does not equal blank