Time Intelligence Filter RRS feed

  • Question




    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!!!!!!!!!!






    Monday, June 23, 2008 2:59 PM


  • 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?





    Wednesday, June 25, 2008 2:53 PM