Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with sales by SKU and a separate data island with a fractile dimension and fractiel percentages. I'm trying to count the number of SKUs with sales greater than or equal to the fractile percentage, however, I'm getting no results. What am I missing in the syntax for the chart expression below?
Count({<Sales_Value = {">=Fractile (Sales_Value,Percent)"}>} SKU)
First test: change Percent to a fixed value, 0.1 for example and change the expression to
Count({<Sales_Value = {">=$(=Fractile (Sales_Value,0.1))"}>} SKU)
Still no results. Just to make sure there was nothing wrong with either table, I added a chart expression of just Fractile (Sales_Value,Percent) and I get the correct results.