Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have several merchants selling products.
I want to see how one specific merchant performs against the other offers.
I want to show this as:
32 of his products are cheaper then the (other) cheapest merchant
5 products are equal with the cheapest
41 products are more expensive then the cheapest price.
Thus I need the min(price) of the merchant, which is in the focus.
And the min(price) of the other merchants excluding the "focus-merchant".
I have those two minimums as:
min(ALL <product_id> { $ <calc_merchant = {"OWN_CLIENT_DATA_FLAG"}>} price)
min(ALL <product_id> { $ <calc_merchant -= {"OWN_CLIENT_DATA_FLAG"}>} price)
now i need to count:
count ( if ( minFocusMerch < minOther, 1 count for cheapest, 1 for more exp)
First problem:
How to get rid off the nested aggr.
Second problem:
How could I use the 3 conditions as 2. dimension for a bar-chart
Hi,
It would be better to understand your problem if you share some data with us.
Regards,
Kaushik Solanki
I know.
I currently have no demo data to share.
only qvf above 30 MB with real data which is under NDA.