not showing rows of under a certain amount

[#1]

hi,

i limited the amount of the expression "Clicks" to >0

by "if(sum(clicks)>0,sum(clicks))".

but when the sum is 0 i get "-" in stead, and i want the row to disappear altogether.

how do i not show rows with clicks=0?

[sunny_talwar]

Technically it should not show it. Do you have a sample where it is showing you '-'??

Best,

Sunny

[#3]

the marked rows are the relevant ones.

[sunny_talwar]

The problem is that you have other expression which are not getting the same null that CVR is getting to force them to be null you need to use this condition for all your other expressions also

If(IsNull([CVR]), yourExpressions)

This will make them null when your CVR is Null and the row will go away.

HTH

Best,

Sunny

[MarcoWedel]

Hi,

try to check "suppress zero-values" and "suppress missing" in the presentation tab of the chart properties.

hope this helps

regards

Marco

[Anonymous]

This is the case for the calculated dimension.  Replace dimension "Campaign ID" with:

only(if(aggr(sum(clicks),"Campaign ID")>0, "Campaign ID"))