Isolating the max date for a date and time stamp

DMJerry
DMJerry
in Magic ETL

Hi,

 

I appending warehouse data on an hourly basis so we can see warehouse activity by hour by day by week and so on.  I am trying to build a filter or indicator that will allow me to filter the most current timestamped date only when needed.  I am using the below beastmode and it's not working.  Any suggestions as I thinking I might be missing something in Magic that I can use to achieve this "flag".  I want to use all the reports sometimes and then just reference the most current other times. 

 

case
   when TIMESTAMP(`Report Time Stamp`) = max(TIMESTAMP(`Report Time Stamp`))
      then 'Y'
               else 'N'
end

 

Any help would be amazing!

 

Thank you all!

Best Answer

  • DMJerry
    DMJerry
    Answer ✓

    Hi,

     

    Nevermind.  I used ranking and just filters on rank 1 to get most current.  

Answers

  • DMJerry
    DMJerry
    Answer ✓

    Hi,

     

    Nevermind.  I used ranking and just filters on rank 1 to get most current.  

Categories