Allow items with zero value to be not shown in workspace

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

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

alyssaf22036961

Avatar

alyssaf22036961

alyssaf22036961

07-02-2019

This feature would be so useful.

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

26-07-2019

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

Avatar

Avatar

jantzen_belliston-Adobe

Community Manager

Avatar

jantzen_belliston-Adobe

Community Manager

jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived