Using cell marks with dates

[spandl]

I would like to confirm a guess:

Cell marks are using an ordinal scale and if I supply dates for the x-axis with a dataset that are missing some dates, these dates won't be rendered. Even if I use interval: 1.

I created a solution in a notebook and would like to know if there are any other alternatives:
https://observablehq.com/@spandl/cells-and-dates

Cell marks act different as line marks. Correct?

Thanks!
ralph

[mythmon]

It looks like that notebook is still private. Can you make sure it is either public or unlisted?

[spandl]

Ouups. Done.

[Fil]

x: { interval: "day" }, should work

Given how dates are encoded, interval: 1 would specify 1 millisecond, which then generates 8 billion bands for 3 months :)

[spandl]

It does indeed, @Fil. Thanks.

And then any time interval can be used as described here:
https://observablehq.com/plot/features/intervals#timeInterval

(why did I try this only on the x-axis 🤷🏻‍♂️ ?)

[spandl]

Somewhat related follow-up question:

x: { interval: "week [month]" }, skips records, if the dataset has daily data.

Is there anything built-in that would aggregate the metrics for an interval? example: calculating the sum or average of all metric values for this interval?

I have done this before with data pre-processing, just wondering if there is a more elegant solution available.

[Fil]

Have you tried with Plot.binX?

[spandl]

No. That indeed that could work.

But, like the excellent example you supplied for aggregating 'others', I think that for reusability reasons, it is easier to prepare the dataset instead of wrapping multiple marks with transformations. (I will show you my solution in some time) 🙏🏼