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

Allow items with zero value to be not shown in workspace

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

225 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

225 likes

Total Posts

465 posts

Correct Reply

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

09-08-2017

When using If condition in calculated metric formula, the unsatisfied values need to be set to '0'.

These line items still show up in the report with zero value and there is no option to have them excluded by default. The most is to display the zero as no value. However, copying these values or extracting them still copies over the underlying zero value and the report it self show these line items.

Example calculated metric:

1275973_pastedImage_7.png

This is how the current setup shows the data with the two options available:

1275981_pastedImage_1.png

Ask: Change the checkbox for interpreting the zero to radio buttons and provide the extra option to exclude values which are having zeroes against them in all columns

1275966_pastedImage_1.png

Additional Ask: If this is idea is implemented, it would be a good idea to show only the total for the qualifying data at the top of the column and not site-wide total.

3 Comments

Avatar

Avatar
Level 1
alyssaf22036961
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
alyssaf22036961
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
alyssaf22036961
Level 1

07-02-2019

This feature would be so useful.

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

114 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

114 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

26-07-2019

Archiving this idea as a duplicate of: Metric Filters  . please continue to vote there!

Avatar

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

331 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

331 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived