QuestionIf each record has an open and close date, how to display active records over time
For example, using the attached data set containing start/end dates for each client, how many clients were active on August 4, 2013?
DATEADD('week',(INDEX() - 1),[Start Date])
IF [Running Date] >= WINDOW_MAX(MAX([Date]))
AND [Running Date] <= WINDOW_MAX(MAX([Closed Date]))
IF INDEX() = 1 THEN WINDOW_SUM([isActive])END
*Optional: To include records that have no closed date, use IFNULL() to convert the NULL values in the [Closed Date] field to some arbitrary future date: