Forum Discussion

emmetk's avatar
emmetk
Frequent Visitor
7 years ago
Solved

Summarize Data by Max Date

Hello!   I have a status transactions table as follows:   date id status 1/1/2019 A New 1/15/2019 A Open 2/1/2019 A Closed 2/15/2019 B New 3/1/2019 B Open 3/15/20...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may refer to my solution here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

I think i have finally solved the problem.  Are you still interested in getting this solution?

emmetk's avatar
emmetk
Frequent Visitor
7 years ago

Hi Ashish_Mathur,

 

Yes, I am still looking for a solution to this! Thank you for continuing to work on this - anything you are able to share would be appreciated.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    You may refer to my solution here.

    Hope this helps.

    • emmetk's avatar
      emmetk
      Frequent Visitor
      7 years ago

      Thank you Ashish_Mathur.

       

      This does solve the problem. However, is it possible to do this without duplicating the input data table for every relevant date? The mock data was only 5 or so records, but your method increased that record count to over 300. Considering my real data consists of thousands of records over many years, this method would not be sustainable in the long run. What do you think?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        It could be unsustainable.  Only you can try and offer feedback.  This is the only method i know.