What percentage of orders in April 2020 were from new customers?
A new customer is keyed on email address.
OrderId : guid
CustomerEmail : string
ProductOrdered : string
OrderedAt : datetime
The way I would approach in SQL (or think I would) would be a a query CTE orders_before_april2020 grouped by email, and a redundant count field.
Then produce another CTE of orders in april that has email, order_before_april_2020_count based on an left outer join to the CTE, then aggregate by by count.
Then group_by to give on a condition of order_before_april_2020_count > 0
Then an MB pie chart.
This currently isn’t possible right for a analyst to do with just the Order table data source in MB?