I want to list my users sorted in the order of orders. Using SQL I can have a query similar to the following
SELECT user_id, count(*) AS num_orders
GROUP BY user_id
ORDER BY num_orders DESC
How do I achieve the same in Mixpanel without having to update the user-profile every time an order is placed.
Best answer by ianView original