I have a Master Calendar (based on PITR example) that is used to select date range.
Includes dates:
Date
SalesDate
I have Sales Data that includes:
SalesDate
ProductCode
Product-CreatedDate
OrderedDate
Could you please guide me as to how I can achieve (flag?) settings in my script, so that I can (for example)
- count the number of distinct products that were created in the selected date range (new products)
- count the number of distinct products that were created outside of the selected date range (old products)
- count the number of distinct products created in the selected date range and that were ordered in the selected date range (new products ordered in this date range).
