#C0303FDCZEZ Hi Team, I would like to request your help in finding a solution to the problem that I am facing on using Druid. I am using druid to store the order related information (sample data attached). For any given date range (start and end date), I need to find two important things 1. The distinct number of new customers 2. The distinct number of repeated customers The new customers are basically the ones that have never ever made a purchase. And the repeated customers are the ones that have made previous purchase. Since, the data volume is huge, I cannot query every row and hence, was thinking of rolling up datasource on day wise and use theta-sketches. Now for a given date range, I can find the new customer by dividing the whole data set into two and taking the 'not' of them. Eg, If A is the theta of all customers before the date range and B is the theta of all the customers in the date range, then B-A will give me the result. However, I am not being able to use similar kind of an approach for a repeated customer. Eg, if a customer C1 makes multiple purchase in the selected date range, then this customer should be treated as new as well as repeatable. How can we solve this using Theta. If not Theta, how can we solve it using Druid?