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
BedrockMission!

Learn More

View all

Sign in to view all badges

How to filter out the unspecified items from a report?

Avatar

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
cathyw49544988
Level 4

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

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
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
Validate 1
Level 2
Issao_Shoji
Level 2

Like

1 like

Total Posts

13 posts

Correct Reply

7 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 5
Affirm 3
View profile

Avatar
Validate 1
Level 2
Issao_Shoji
Level 2

Like

1 like

Total Posts

13 posts

Correct Reply

7 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 5
Affirm 3
View profile
Issao_Shoji
Level 2

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

Avatar

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
cathyw49544988
Level 4

11-10-2017

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

Thanks,

-Cathy

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
hyderziaee
Employee

11-10-2017

It should work:

1322399_pastedImage_4.png

1322395_pastedImage_3.png

Avatar

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
cathyw49544988
Level 4

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

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
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

Avatar

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
cathyw49544988
Level 4

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

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
hyderziaee
Employee

11-10-2017

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

Avatar

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
cathyw49544988
Level 4

Likes

36 likes

Total Posts

155 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
cathyw49544988
Level 4

12-10-2017

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