Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.