Is there a way in LookML or within the Explore itself to replicate the following SQL query - where `order_id` and `customer_id` are dimensions?
The issue I’m having is I want to have `customer_id` in the GROUP BY clause but not in the SELECT clause, and I also want to have `order_id` in the HAVING clause.
SELECT SUM(count_order_id) AS total_orders_made_by_same_customers
COUNT(order_id) AS count_order_id
GROUP BY customer_id
HAVING COUNT(order_id) > 1