Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Previous Week variance

Hi,   I want to pull in the previous week into the table, so for example next to week thritheen i want to show week 12 and then do a variance on it.   How would I pull in the previous week?   T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

hi kcantor

 

Thanks for that but when I put it in my table I get a contigous date error?

 

Thanks

 

Chris

kcantor's avatar
kcantor
Community Champion
9 years ago

Anonymous

That error means that you do not have a complete date table (with no missing dates) or that your columns are not filtered correctly. 

Make sure your date table is complete and pull your week numbers from there. You may also need to filter by year or put year on the columns as well.

It could also be that you are pulling your week numbers from the fact table instead of your date table.  If you share a sample of your data I would be happy to look at it a little closer.