Highlighted

How to filter out the unspecified items from a report?

Avatar

Avatar

cathyw49544988

Avatar

cathyw49544988

cathyw49544988

10-10-2017

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

Thanks,

Replies

Highlighted

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

10-10-2017

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

Avatar

Issao_Shoji

Avatar

Issao_Shoji

Issao_Shoji

11-10-2017

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

Highlighted

Avatar

Avatar

cathyw49544988

Avatar

cathyw49544988

cathyw49544988

11-10-2017

If it is a text field, then what I should do?

Thanks,

-Cathy

Highlighted

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

11-10-2017

It should work:

1322399_pastedImage_4.png

1322395_pastedImage_3.png

Highlighted

Avatar

Avatar

cathyw49544988

Avatar

cathyw49544988

cathyw49544988

11-10-2017

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

Highlighted

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

11-10-2017

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

Highlighted

Avatar

Avatar

cathyw49544988

Avatar

cathyw49544988

cathyw49544988

11-10-2017

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

Highlighted

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

11-10-2017

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

Highlighted

Avatar

Avatar

cathyw49544988

Avatar

cathyw49544988

cathyw49544988

12-10-2017

Actually I think we should as adobe to enhance and support this feature. Correct?