Customers with completed or recovered orders in a date window, split per connection (store) into new (one order in the window), repeat (more than one order in the window) and inactive (latest order in the window is more than 90 days before the end of the window). Inactivity is measured from endDate, not from today, and only orders inside the window are looked at, so a window of 90 days or less, including the default 30-day window, never has inactive customers. The three groups do not overlap, so they add up to that connection total_customers. Because a customer who shops at two stores is counted once for each, the grand total_customers is not a count of distinct people. Pass behaviorType to add figures for one group.