topic using stats function to return latest value but need associated timestamp of that value in Splunk Search https://community.splunk.com/t5/Splunk-Search/using-stats-function-to-return-latest-value-but-need-associated/m-p/367367#M108373 <P>stats latest(sequence)returns the latest sequence number but I need to display the associated timestamp when the sequence number was received.</P> Mon, 08 May 2017 13:07:07 GMT erhksadhwani 2017-05-08T13:07:07Z using stats function to return latest value but need associated timestamp of that value https://community.splunk.com/t5/Splunk-Search/using-stats-function-to-return-latest-value-but-need-associated/m-p/367367#M108373 <P>stats latest(sequence)returns the latest sequence number but I need to display the associated timestamp when the sequence number was received.</P> Mon, 08 May 2017 13:07:07 GMT https://community.splunk.com/t5/Splunk-Search/using-stats-function-to-return-latest-value-but-need-associated/m-p/367367#M108373 erhksadhwani 2017-05-08T13:07:07Z Re: using stats function to return latest value but need associated timestamp of that value https://community.splunk.com/t5/Splunk-Search/using-stats-function-to-return-latest-value-but-need-associated/m-p/367368#M108374 <P>just add <CODE>latest(_time) as _time</CODE></P> <P><CODE>stats latest(_time) as _time latest(sequence)</CODE></P> Mon, 08 May 2017 13:57:40 GMT https://community.splunk.com/t5/Splunk-Search/using-stats-function-to-return-latest-value-but-need-associated/m-p/367368#M108374 rjthibod 2017-05-08T13:57:40Z