1 Reply Latest reply: Oct 6, 2016 10:22 AM by Lakshmikandh Karthikeyan RSS

    Associating data to time frames (Last 24 Hours, Today, Last 30 Days, etc)

    Nick Listerman

      I'm querying in incident data and the incident created on time stamp.  During load I want to associate my data with their appropriate time frames.  Example: if an incident was created today it would belong to last 24 hours, today, and last 30 days but if an incident was created a week ago it would only belong to last 30 days.  Is there a way to loop through the data and create a second table that tracks the incident number and the multiple time frames it should appear in when selected?