Hey, Wanted to let you know, that the Business Journey worked like a charm! It took me awhile to get it working, but once I did, it worked great! But now, I have another question! What we are doing here, is sending a NEW order status and an order number, and an ASSIGNED order status and the order number, from 2 different places in the order flow. The new Business Journey we created, has only those 2 milestones... NEW, and ASSIGNED. Occasionally, there are orders that get stuck, between NEW, and ASSIGNED. And with this Business Journey, we are able to identify the order numbers, of the stuck orders, because they don't complete the Business Journey, so the 'complete' column shows 'false' for those orders. But it takes an average of 2 minutes, under normal circumstances, for the order to flow from NEW, to ASSIGNED. So we tried to write a query that would return 'completed'= 'false' (no problem, there), but then additionally, we wanted to add a condition to the query that would say 'don't return any orders that are not at least 10 minutes old.' There is a 'NEW_Orders.eventTimeStamp' value, but so far, we can figure out a way to say... AND 'New_Orders.eventTimeStamp' is older than 10 minutes. We figured out a way to bucket them, but I need to return a single value as a count, so I can use the search to create a metric that I can use in a health rule. Here is the first part of the query... SELECT * FROM magento_order_flow WHERE completed = false Thanks for turning me on to the Business Journey thing. It was a tremendous help. Thanks, greg
... View more