Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a possibility to automatically subdivide different prices of a product into 5 separate price ranges?
i.e. (highest price-lowest price)/5 = price difference --> lowest price + price difference= first price range
Thanks for your help!
Should be possible by creating two variables for min and max price:
=min(PriceField)
=max(PriceField)
then using a calculated dimension:
=class(PriceField, (vMaxPrice-vMinPrice)/5 ,'x',vMinPrice)
and as expression what you like, e.g. count(distinct SupplierCompany)
Regards,
Stefan