I tried "does not contain" "Unspecified". But it won't work. I believe it is null value. So what should I use?
If this doesn't work, can you give more information about the report(variable) you are running and the tool you are using(RnA/Workspace/Report builder)?
Depending on your data, is you're trying to see just number, you would try 'filter'>'Advanced Options'; 'if any criteria are meet', 'contains one of': 0, 'contains one of': 1... until 9.
Or you would try it in workspace, there you can filter does not contain > none.
So you will need to use workspace, add a segment to filter it out.
Right now, my users are using the regular report. Is there a way to filter it out?
It is Unspecified in Reports, and None in Workspace. Will work with any metric as well.
See the following screenshots. When I use Doesnot contain Unspecified, then it filtered out the unspecified from the chart, but still showed in the table.
Okay, I understood my mistake.
You can not do this by filter. You will need to create a segment.
Thanks. It worked. Then I noticed one thing. It filtered out the null values. But the % value didn't re-calculate. Is there a way to show the re-calculated %?
Hello - Filtering won't re-calculate, you have to use segment for re-calculation to apply.