3 Replies Latest reply on Oct 13, 2018 11:06 AM by Deepak Rai

    Creating a measure to measure when an event happened

    Christina Gee

      I am trying to create the following table where I can calculate how old the device was when an event happened. I currently have deviceid, days old, event happened (0/1) and report date. I am trying to create 2 columns that records the date from when the event switched from 0 to 1 or was already at 1 (date of event) followed by another column that will report "How old was the device when the event happened."

       

       

         

      deviceiddays oldEvent Happened?report dateDate of EventHow old when event happened?
      123001-Oct3-Oct2
      123102-Oct3-Oct2
      123213-Oct3-Oct2
      123214-Oct3-Oct2
      8021011-Oct1-Oct0
      8021212-Oct1-Oct0
      8021313-Oct1-Oct0