Dimension with several conditions

[sifatnabil]

Hi all,

I would like to get the list of customers who fulfill these conditions:

1. Have orders live on screen for at least 6 hours a day with eflag="E" on at least 3 distinct instruments

2. Fulfill the above condition for at least 15 days in a month

I started off with a chart with dimension like this:

=if(EFLAG='E',if(aggr(count(distinct {<EFLAG={'E'}>}INSTRUMENT)>=3,CUSTOMER,DATE) and aggr(sum(OrderExit-OrderEntry)>=0.25,CUSTOMER,DATE),CUSTOMER))

and Expression: Interval(Sum(OrderExit-OrderEntry))

But this doesn't seem to work. Is there a better way to yield all customers who fulfill these conditions?

[sunny_talwar]

Its a fairly complex requirement, this can be either solved by Stefan without a sample or you would need to provide a sample for others to try it out

Best,

Sunny