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

Allow items with zero value to be not shown in workspace

Avatar

Avatar
Give Back 400
Employee
hyderziaee
Employee

Likes

231 likes

Total Posts

465 posts

Correct reply

222 solutions
Top badges earned
Give Back 400
Give back 300
Give Back 200
Give Back 100
Give Back 50
View profile

Avatar
Give Back 400
Employee
hyderziaee
Employee

Likes

231 likes

Total Posts

465 posts

Correct reply

222 solutions
Top badges earned
Give Back 400
Give back 300
Give Back 200
Give Back 100
Give Back 50
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
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

316 posts

Correct reply

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

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

316 posts

Correct reply

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

26-07-2019

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

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived