Time Dimension with only Year - no months

Occasional Contributor

Time Dimension with only Year - no months

Hi All,

I am trying to bring in only Year data (no month or Quarter) but I do not seem to have only Years when I choose the Time. 

I am trying to get data for FY16, FY17, FY18, and then trying to do average of FY16 and FY17, and FY17 and FY18. 

I tried hiding the months, however, when I use the Period or Lead or Lag, it looks at the month.

Any ideas?

Message 1 of 2
1 REPLY 1
Highlighted
Contributor

Re: Time Dimension with only Year - no months

Hi @khoonks,

 

In the Blueprint mode of your module, choose Year as Time Scale (See attached screenshot),that will give you only Year and you can also use Lead/Lag functions.

 

Thanks

Sathya

 

Message 2 of 2