Metrics & Partition keys

[silja.mardla]

And here is my related question. By putting date filters into the metric definition itself, I am probably messing with the different grain options in an incompatible way

Best practice to incrementally materialize metrics with different time grains

I am wondering on how to set up incremental materialization of metrics that have different time grains. Let’s say I have a metric that has day, month and year grains. Every day I want to materialize its values into two different tables: one with daily grain, one with monthly grain. Daily table materialization can probably be set up in a way that I always calculate the data for the previous full day and I never really have to merge anything, just insert new rows one day at a time. But what abo…