There are orders (non-unique) that can have multiple services assigned to them and can also have different vendors assigned. Trying to identify a way in Domo to weed out some orders that fit these criteria:
- If an order has 2 or more services under the same order number and if the order has at least one service code ‘GB’
- Order must have had at least 2 or more different vendors assigned to it
Example: (Services will have an alias like Service.. while GB is explicitly used)
Order 123456 has three different services under it. Service1 assigned to Vendor1, Service2 assigned to Vendor2, GB assigned to Vendor2 (We want to display this order)
Order 654321 has three different services under it. Service1 assigned to Vendor1, Service2 assigned to Vendor1, GB assigned to Vendor1 (We don’t want to display this order because there was only 1 vendor involved in this order)
Order 789 has three different services under it. Service1 assigned to Vendor1, Service2 assigned to Vendor2, Service3 assigned to Vendor3. (We don’t want to display this order because there was no ‘GB’ service in this order)
Is this possible to achieve with a beast mode? I am trying to think of a way to tackle, but can't see picture how it'll work.
