5 Replies Latest reply: Aug 25, 2011 9:10 AM by Donald Hutchins RSS

    regarding date range selection

    Sushil Kumar

      Hi ALL,

       

      I want to give functionality in my dashboard to enter date range manually..

       

      So for that i created two variable vStartDate and vEndDate

       

      in my time dimension table i have field TIME_DATE in 24/07/2011 12:00:00 AM format...

       

      I created two calender object to enter the value with min value as =Min( {1} TIME_DATE) and max value as =Max( {1} TIME_DATE)

       

      and in my chart i applied condition as Sum ({<TIME_DATE={">=$(vStart)<=$(vEnd)"}>} TOTAL_DEFECTS))

       

       

      But i am not getting results... when i checked the variable value, it is found to be 48750.93333...

       

       

      Please help me out to find out that wt mistake i did in this...

       

       

      Thanks...