Frequently Asked Questions about LoopInsights:
LoopInsights provides SQL aggregate functions to visualize calculations using the set of values sent to charts on LoopInsights. You can specify a timeframe on LoopInsights charts to determine the values to aggregate with SQL functions.
time_stamp is the date and time of the event
|Using event_date for small intervals, such as last N minutes or hours can produce unexpected results.|
For example, if you create a chart and set Since to 1 minute ago and Until to Now, if you use event_date you will get the average value of the metric for the last day. If you use time_stamp for the same conditions you will get the average value of the metric for the last minute.