2 Replies Latest reply on Nov 5, 2018 5:26 AM by madhuri.gajjala

    How to show first 5mins Sales from max timestamp


      Hi Everyone,


      I have a requirement to fetch max timestamp sales which we usually get "window_max(max([Submitted date]))", i need to extract first 5,10 mins & 1hr sales from max timestamp obtain.


      consider Superstores data as an example:

      Max time stamp might be "11/5/2018 4:45:00 AM"  for which Sales as $900M,from obtained timestamp,i should extract first 5 mins sales such as " "11/5/2018 4:05:00 am"


      How can we extract these timestamp and corresponding sales.


      any help which appreciated !