Hello, I made this example data set to show the issue I am working through:
New Table("Project Status",
Add Rows(5),
New Column("Project", Character, "Nominal", Formula("Project " || Char(Row()))),
New Column("Start Date", Numeric, "Ordinal", Format("m/d/y", 12), Formula(Date Increment( Today() - In Days( Row() * 10 ), "Day" ))),
New Column("End Date", Numeric, "Ordinal", Format("m/d/y", 12), Formula(Date Increment( Today() + In Days( Row() * 10 ), "Day" )))
);The following code will create a 5x3 Data Table with beginning and end dates for 5 different projects. What I would like to do is get a count of "projects in progress" for all month/year combos in the data set. By that I mean any project that's beginning date should be counted for that month until the end date has passed. Here is an image example of what I am hoping to produce:
Is there a way to get these counts into their own data table using JSL?
Please let me know if I can provide any more info on what I am trying to accomplish.
Thanks
