Combo Chart Markers visibility condition

victor_jacquens — Mon, 20 Dec 2021 21:02:46 GMT

Hello,

I have a combo chart on my app that displays the stock of products by class, and I would like to add a marker for stock limit on some of them. I've used the marker option to do so but I wanted to know if it was possible to hide the makers where the limit value is 0 (when the limit is 0, there is no limit).

Here's how it looks for now:

Is there any option or expression condition to only keep the markers I want?

Thanks in advance

Re: Combo Chart Markers visibility condition

victor_jacquens — Tue, 30 Mar 2021 08:01:20 GMT

Hello everyone,

I have found a solution. Since I only have 1 "Stock Limit" value per product category, and since when there is no limit, the "Stock limit" column is empty, I switched the marker expression from "Sum([Stock Limit])" to "Avg([Stock Limit])", since the average of nothing is nothing, where the sum of nothing was 0.

topic Re: Combo Chart Markers visibility condition in App Development

Combo Chart Markers visibility condition

Re: Combo Chart Markers visibility condition