Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have data:
stores: logo, name, limit_from, limit_to
orders: logo, client_id, value, order_id
I need to calculate to each store orders with the value between limit_from and limit_to (different for stores).
I have an expression:
count({<value={">$(limit_from)"},value={"<$(limit_to )"}}distinct order_id)
but it is true for every row, I have the same answer like expression count(distinct order_id)
Thanks for Your help.
Try this expression:
AGGR(COUNT({<value={">$(limit_from) < $(limit_to )"}>}DISTINCT order_id),name)
Hope this might help you!
Try this expression:
AGGR(COUNT({<value={">$(limit_from) < $(limit_to )"}>}DISTINCT order_id),name)
Hope this might help you!
So simple and it works!
thanks! m.