topic Re: How to restrict dynamically the range of data displayed on x-axis? in App Development

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

phraid — Mon, 08 Apr 2024 15:45:37 GMT

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

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

mpc — Tue, 09 Apr 2024 08:34:56 GMT

Hi,

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

Regards

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

marcus_sommer — Tue, 09 Apr 2024 11:16:50 GMT

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)