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

    How to show first 5mins Sales from max timestamp

    madhuri.gajjala

      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 !

       

      Madhu