Forum Discussion
Cummulative Trending View
Hi, I wanted calculate a cummulative view. My table looks like below, Loan ID Date Status 1 2-Jan Contracted 1 3-Jan PTD 2 4-Jan Contracted 3 5-Jan Contracted 4 1-F...
Hello Sir,
Sorry for the trouble!
In the above corrected file you have attached, i have tested with a pat_id 9936 for the year 2022 like below,
The dataset for this pat_id,
For the september month there are 4 event_names and the most recent even is the full loan amount considering the timestamp. So the expected output for september and october should reflect only full loan amount and
similarly for november and december it should be Payment processed( since the most recent event_name is payment processed considering the time stamp).
But we could see all the status since we considered only the date in the calendar function.
Is it possible to change this with the timestamp?
It could be of great help if you could give me an insight!
Thanks