Narrow down expressed values by setting some conditions/limits?

[#1]

Hi Guys,

I'm trying to show expression values that are over 4,000 in below chart, which means only showing value 13,722 and 4,454, and off course their corresponding dimensions. How can I achieve that? The original expression here is simple as a SUM().

Set analysis seems not working on this.

Thank you!

Jia Junqing

[Gysbert_Wassenaar]

On the Dimension Limits tab enable the Show only values that are option and choose the Greater Than or Equal To option. Enter 4000 in the input field next to that and finally choose exact amount in third input field.

Alternatively you can try a set analysis expression: sum({<YourXaxisDimensionHere = {"=sum(Amount)>=4000"} >}Amount)

[sunny_talwar]

Or you can always use the if statement (which might be the only way if you have more than one dimension, unless you can uniquely define the two dimensions using a single field)

If(Sum(Amount) >= 4000, Sum(Amount))

[#4]

Hello, Gysbert,

What if I have 2 expressions need to be conditioned, how to connect the two conditions for "YourXaxisDimensionHere", I tried setting conditions for each of the expressions, but the logic seems not AND, but OR. For example, I have below 2 expressions but I only want the dimension with columns red circled showing off.

Expression#1: SUM(Amount)

Expression#2: Count(Number)

Jia Junqing

[sunny_talwar · Accepted solution]

May be this for and AND logic:

Sum({<YourXaxisDimensionHere = {"=sum(Amount)>=4000 and Count(Number) > X"} >}Amount)Re: Narrow down expressed values by setting some conditions/limits?

[#6]

Thank you! works!