Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 qvds. Ticket and Order. TICKET_ID is common in both vds.
Ticket.qvd - > TICKET_ID, TICKET_STATUS
Task.qvd-> TICKET_ID, ORDERID, ArriveTime(min),
I need to calculate Tickets with more than 1 task having more than 30 mins TravelTime.
I dont want to join 2 models because of performance issues.
Is it possible to make this with set analysis ? Something like below
count({$<TICKET_STATUS={"closed"}, Aggr(Count(TravelTime = {">30"},ORDERID)={">1"}>} TICKET_ID)
Thanks in advance.
Thanks a lottt. This works perfect