I am using airtable to track and manage activities in a plan.
the relevant table has a baseline date field, a latest planned date field and an actual date field.
Not every task has each date completed
I want to plot cumulative progress (count the number of tasks due to be complete, or complete) over time.
I am using Vega Lite to plot cumulative graphs.
Within Vega-Lite I am using filters to remove the records with no dates, then use window and count operators to generate cumulative values.
I can plot each graph independently, but if I try to layer, vconcat or hconcat the three graphs together than the filtering either cuts off the baseline fields or creates an incorrect jump at the start of the planned/actual dates as null dates are passed to Vega Lite as 01-01-1970.