Forum Discussion

renlaforest's avatar
renlaforest
Icon for Helper I rankHelper I
3 years ago
Solved

Additonal rows by ID with previous value for each day

Hi - I have a dataset that provides historic values for each ID. So, the status for ID 574142 went from 0601 on September 13th to 0803 to September 16th. My goal is to have the count of each status ...
Need Help
Tips and Tricks
renlaforest's avatar
renlaforest
Icon for Helper I rankHelper I
3 years ago

Thank you for the response. Maybe I should have been clearer with what I need. I basically need the count of current status (at the time). So, for these two homes in the example file, it would end up looking like this:

  • renlaforest's avatar
    renlaforest
    Icon for Helper I rankHelper I
    3 years ago

    Thank you lbendlin - I'm not sure how the data doesn't match the expected result. Both start out as 0601 on September 13th, then are 0803 on September 16th, and one of them, 5750263, switches to 0805 on September 27th, while 5754142 remains 0803 until October 20th (when it switches to 0402 and stays there).