Cummulative Trending View

Hi Sir,

Thank you so much!

You can download the file below,

https://drive.google.com/drive/folders/1kUJEzxtkH40lzd3h4FvOuysf9JPo8_FS?usp=sharing

It is the file you have shared me prior with filter applied on the visual for a particular pat_id 9936 for year 2022. 

The dataset for this pat_id is below,

Expected output: 

For the september month there are 4 event_names and the most recent event is the full loan amount considering the timestamp. So the expected output for september and october should reflect only full loan amount (the graph for should show only Full Loan Amount Event and should not show the other 3 event_names like Application Link Sent, Application Complete and  Approved) and

similarly for november and december it should be Payment processed( since the most recent event_name is payment processed  and begin treatment considering the time stamp and should not show the event_name Payment Pending). 

Please Help me with this.

Thanks,

Dharani