2 Replies Latest reply: Aug 28, 2012 1:48 PM by Göran Hofstedt RSS

    point in time?

    Göran Hofstedt

      Hi

      whould be very nice if someone can help me with what I think is point in time(?)

       

      I want to show the Id:s that have been active for a minimum of 10 months from latest event date. I have the following tables

      Id

      Eventdate

      Master calendar with the usal stuff, month, year, date,fiscal etc counters for thoose and some rolling 3 and 12(?)

       

      If a Id has  only one eventdate 10 months back and one this month I want to count it as a "hit"

      if it has a eventdate 15 months back and regular hits up today its also counts

       

      How can this be done, any suggestion?

        • Re: point in time?

          Do you want this is a chart or in the script?

           

          I am assuming that you have ID also in the eventdate table to link data.

           

          in the script you can do a group by resident table:

           

          SummaryEvent:

          MIN(Eventdate) as 'First Event',

          MAX(Eventdate) as 'Last Event',

          ID,

          if(MIN(Eventdate)<=ADDMONTHS(MAX(Eventdate),-10),'Over 10 Months Active','Under 10 Months Active')

          Resident Eventdate Group by ID;