Making a custom dimension from scratch using expression = now() creates a new table with 1 column and 1 row and cross joins that onto your look.
Is it possible to make a custom dimension from scratch (ie, not referencing any views) with more than 1 row, for example, a range of dates?