Newbie here with little experience in coding (medical background).
I was given this database which contains all hospital admissions during a 1 year period.
Each row represents an individual admission, and columns contain variables like date of admission (YY/MM/DD hh:mm) or source of admission (home, transfer from other hospital, etc).
![JP27_1-1683222803197.png JP27_1-1683222803197.png](https://community.jmp.com/t5/image/serverpage/image-id/52563i4DAB39605EA49CFA/image-size/medium?v=v2&px=400)
This is a very simplified version of how my table looks like. Actual table contains thousands of admissions. Admission date is in ascending order.
I was instructed to develop a forecasting model to see how many admissions we can expect in the following month/year based on this data. I did a bit of research and consider that a Time Series analysis could work for our purpose. It should be something simple: to forecast future daily admissions based on current daily admissions.
The only way I have been able to get some output was by using by admission date variable in the Y axis, and I am getting something like this:
![JP27_0-1683222583533.png JP27_0-1683222583533.png](https://community.jmp.com/t5/image/serverpage/image-id/52562i8FEE9BAABE8B885F/image-size/medium?v=v2&px=400)
Instead, I am hoping to get something like this:
![JP27_2-1683223036043.png JP27_2-1683223036043.png](https://community.jmp.com/t5/image/serverpage/image-id/52564i60F486AA889034ED/image-size/medium?v=v2&px=400)
I know I am probably missing some super basic concepts. I read and did the exercises in the JMP book but still I can't solve this. Thank you in advance!