8 Replies Latest reply: Jul 5, 2011 5:20 AM by Sushil Kumar RSS

    how to load previous day data

    Sushil Kumar

      Hi All,

       

      I need to develop an application in which there is a time dimention with Time_date and time_id fields..

      I want to load/schedule my application in such a manner, it has previous day data avaliable...

       

      Means how to get the previous day data and  aply the filter....

       

       

      Thanks..

        • how to load previous day data
          Kaushik Solanki

          Hi,

           

             Do you mean to say your application should have only Pre. Day data. or do you mean you need pre. and today data too.

           

             And what filters you are applying and on what.

           

             Please describe in more details.

           

          Regards,

          Kaushik Solanki

          • how to load previous day data

            I think you want to show the comparison between the current date and previous date data in a chart may be a straight table or a barchart.

            U can write that code if you have a date field in ur table structure.And Date must be in proper Date field,not in string actually...

            Current Date Data:--sum({$<Date={$(=Max(Date))}>} Sales)

            Prev. Date Data:--sum({$<Date={$(=Max(Date)-1)}>} Sales)

            Try and reply me.

            Thanks and regards,

            Koushik.