Our time dimension is Year Qtr Month Business Day#.
Data is coming from our customer table.
Ex categories for Jan
2016 Qtr 1 Jan Day 1 up to Day 25
2015 Qtr 1 Jan Day 1 up to Day 21
We created 2 relative time categories:
Current Day
Same Day Last Year
Our problem is on Jan,2016 Day 22
Current Day = Day 22
Same Day Last Year = Feb,2015 Day 1
Is it possible to show Day 21 as Same Day Last Year or not show at all?
Why is it going to new period? Is this how Transformer is supposed to work?
Thank you
I changed the definitions to below. The Current Day and Same Day Last Year now matches!
For Same Day Last Year:
Under Relative Time
Basic Approach = Single Category
Target Period = Day Target Offset = 0
Context Period = Month Offset 12 (our year is in descending order that is why it is +12)
( Before the change: Context period = Year Offset =1)