I recently built a new field for my dataset in Excel that added certain employees into specific groups. Most employees are not in these groups, so when I joined that field to the rest of my dataset most of the fields are blank. This should be fine.
However, when I add this field as a filter into any dashboards or charts, it does not allow me to filter by ‘blanks’ or exclude all of the groups. If I do this, no data is returned.
The field is incredibly basic and laid out like:
“Employee Group:
Group 1
Group 2
Group 3”
If an employee is not part of a group, a blank field is created as it's joined. I would like to be able to filter by employees not a in a group.
I have plenty of other columns with blank fields, such as ‘Exit Date’. If an employee has not left the company, ‘Exit Date’ is blank and I have no problem sorting by employees with a blank exit date. Therefore, this problem makes absolutely no sense to me.
Additionally, if I do an ‘ifnull’ formula, it overwrites everything including fields with values.