locked
Time Intelligence Filter RRS feed

  • Question

  •  

    Hi,

     

    Im creating a Time Intelligence filter.

     

    Formulae used:

    Month+3:Month+12(As my Financial Year is 4m Sept to Aug).

     

    It is displaying data from Sept to June(With empty rows in June month as dere is no data).Were in I actually want June month to be displayed only if dere is data in database.Dat is, it has to pick up de data & display on de dashboard for June only if data is available.Similarly for the other coming months.

     

    I also used Month+3:Month+11,which displays till may.Will it add June month if data is available for displaying,automatically.And, ll sept b lost as June is getting added.

     

     

    Can any1 help me out with dis!!!!!!!!!!

     

    Thanks

     

     

     

    Monday, June 23, 2008 2:59 PM

Answers

  • The time intelligence filters work off of the current system date.  So, since today is June 25, Month + 3 yields, September.  Month + 12 yields June of 2009.  When we get to July 1st, Month+3:Month+12 will yield all months from October to July 2009.

    Does that help?

    Thanks,

    Alyson

     

     

    Wednesday, June 25, 2008 2:53 PM