Weekly Data Roll-up in DataNav

2.78K viewsDataLink
0
0 Comments

Hi,

Is there a way to roll-up daily data into weeks? Ideally I’d like to do this in the Date Field Quantizer when configuring the dimension, but it looks like it only rolls up days, months and years.

I suppose I could put together a reference table, that lists days as items in a dimension, put a week counter in the cells and use the ‘Using As’ function. But I’m wondering if there’s a different way.

Thanks,
Rich

0

Hi – we don’t have a full calendering system in Quantrix so weeks is not possible but I think it is a good suggestion. We add your vote to this in our database for future release consideration.

The reference table idea is probably the best way forward.