How can I get the first time of the data that got sold and also last time that got a sold in a day.

Follow

Master Yoda

November 14, 2019 09:14

I want to get the first time and last time of that the agent sold per day.

0

• 

  Ido Darnell November 19, 2019 10:23

  Hi Master Yoda, 

  This sounds like a modelling challenge,

  Assuming this information is coming from the same table, (if not you could achieve it with another step in between)

  You could create a custom column which concats the [Agent] and [Date] (without timestamp)

  Then add 2 custom columns, with the SORTASC([Agent+date],[timestamp])

  And another one with the same with SORTDESC([Agent+date],[timestamp])

  Then select only the rows which have 1 values, this will give you the first and last time that agent sold that day.

  Another way would be to translate these timestamps into INT and get the max/min for each agent for each day,

  Let me know if you'd like any further clarification or if you'd like to discuss on a quick call,

  ido.darnell@qbeeq.pl

  We're always here to help,

  "Always pass on what you have learned" -Yoda

  0

  Comment actions Permalink
• 

  Master Yoda November 21, 2019 07:40

  Hi Ido, 

   

  Thanks for your help. Can you elaborate more on how to concat the agent and date ? should the date will be string ? I already extracted the date from the timestamp by using the createdate but when I concat it. It showed an error that says the fuction concat is not declared.

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.