How to restrict dynamically the range of data displayed on x-axis?

[phraid]

Hi 

I have the following dataset:

I display the nb of sales with accumulation per DCP and it works fine:

Starting from that point, I want to display only the DCPs equal or superior to 2 for instance (obviously, in my real case, the limit (2 here) is more complex and is based on a computation taking into account other fields of the table that I don't show here... but let's start "simple" and it is important to notice that I cannot apply a manual filter).

I edited the expression with something like: 

Sum({$<DCP = {">= 2"}>} NbSales)

But it still displays all the DCPs, whereas I would expect to not see the DCPs 1 and 0. 

Any ideas would be very appreciated 😀

Regards, Fred

[mpc]

Hi, 

I've you tried to uncheck Include 0 values the Data handling secion ? 

Regards

[marcus_sommer]

If you didn't want to show all values and/or limiting them in any way you will need to apply appropriate conditions to your expression, simplified something like this:

if(Condition1, MyExpression1, if(Condition2, MyExpression2, 'myDefault'))

whereby 'myDefault' might be also NULL or ZERO or the (TOTAL) max. Value/Count of any dimension/expression.

Beside applying everything in (nested) if-loops you may also use a wrapping with range-functions like:

rangemin(MyDefault, MyExpression)