Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to filter out the unspecified items from a report?

Avatar

Level 6

I tried "does not contain" "Unspecified". But it won't work. I believe it is null value. So what should I use?

Thanks,

12 Replies

Avatar

Employee Advisor

Try 'exists'.

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

Avatar

Level 2

Hello

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.

Regards,

Mauricio Shoji

Avatar

Level 6

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?

Thanks

Avatar

Employee Advisor

It is Unspecified in Reports, and None in Workspace. Will work with any metric as well.

Without segment:

1322415_pastedImage_3.png

With Segment:

1322416_pastedImage_4.png

Avatar

Level 6

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.

1322423_pastedImage_0.png

1322424_pastedImage_1.png

Avatar

Employee Advisor

Okay, I understood my mistake.
You can not do this by filter. You will need to create a segment.

Avatar

Level 6

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

Avatar

Level 5

Hello  - Filtering won't re-calculate, you have to use segment for re-calculation to apply.

Regards,

Saurabh Kumar.