Transformer 2 Facts Multiple Date Granularity

[zip159]

This sounds like some of the other questions I've seen on this forum but those didn't help me figure out my problem.

I have 2 fact tables, sales and inventory.  The sales data is by day but the inventory data is by week (stored on the last day of the week).

The users want to be able to see summed up sales data along side average inventory data.  I haven't been able to figure out how to tell Transformer to treat the sales metrics as daily but treat the inventory data as weekly.  I changed the inventory time state rollup to average but that is taking the average at a week level too. For example, if we had 1000 pieces at the end of the week the cube is showing 1000/7 for the weekly inventory number because all other days have 0 for the inventory.