It does not seem to be possible to take the minimum or maximum of a date using the aggregation feature of a recipe.
Second question. Filtered aggregates are also not possible it would appear. If I want to know the count of all activities, the count of all emails, and the count of all calls (with email and call being the two options for activity type), it doesn't appear that a recipe can do all three together. It can either do the total, or separate emails and calls by adding a column group, but not all three. (I have found a workaround by creating a transform to add the two together but that isn't the point here)
Am I missing something or are these really not possible? Basic features of SQL.
@Drew Hibbard You're not missing anything. Using the Aggregate node with a grouping column and adding those values afterwards in a transformation node is the way to go.
