Using date dropdown to manipulate a card that aggregates using two different dates
case study: I want to create a card that for a given date range, it returns the number of orders taken and the number of orders completed. The dataset has one record per order, and there is a "order taken" date field and a "order completed" field. I could use SQL to create a dataflow that that creates one record per month…
