Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am facing an issue, i heave date pickers and two list boxes like as below.
| Originate team |
|---|
| ABC india |
| ABC singapore |
| cs india |
| xyz |
| Assigned team |
|---|
| ABC india |
| MNO corp |
| xyz ltd |
| abc singapore |
| KLM Prod |
Issue: usually tickets are assigned to aaigned team and orinating by orginating team most of the tickets are handled by originating team.
but few tickets are handled by assigned team.
EXAMPLE: if i have 100 tickets assignd to ABC india and in that 90 tickets are handled by ABC india in originating team. remaining 10 tickets are handled by abc singapore.
Problem: i have given date range and when i select ABC india(Originating team) it is giving 90 tickets. but actual tickets are 100.
when i select ABC india i need count 100 how can i get please help me.
Thanks.
May be this:
Count({$+<[Assigned team] = p([Orginiate team])>}Tickets)