Forum Discussion

Rally00's avatar
Rally00
Frequent Visitor
4 years ago
Solved

Help Max date

Hello everyone, for a table I should group the values ​​by max date. In particular, for each ID I should have the maximum date   ID Date 0WO1i000001yEKeGAM 12/03/2022 0WO1i000001yEKeGAM...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Rally00 

     

     

    Did I answer your question? Thanks to mark my post as a solution 

     

  • mh2587's avatar
    mh2587
    4 years ago

    Remove the extra closing square bracket .[Date]]

mh2587's avatar
mh2587
Super User
4 years ago

Just select the earliest date option in the field section by clicking drop option you will see earliest date option

Rally00's avatar
Rally00
Frequent Visitor
4 years ago

Thanks for the answer but sorry I didn't understand. I forgot to mention that the result of the max will then join with another table via the ID

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

    Would you please upload the screenshot of the visulization pane of the right side