another variable in selection

[mv]

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. 

[agigliotti · Accepted solution]

maybe this:
count( distinct if( value > limit_from and value < limit_to, order_id ) )

[bharatchauhan · Accepted solution]

Try this expression:

AGGR(COUNT({<value={">$(limit_from) < $(limit_to )"}>}DISTINCT order_id),name)

Hope this might help you!

[mv]

So simple and it works!

thanks! m.