Discharge department

[bdeleur]

Hi,

I want to make a report witch contains the following information.

Out of a big data file I want to extract the follow up department.

So I have department A and how many have a transfer (discharge) to deparment B & C etc.

Reference	Start date	End date	Discharge (out of hospital)	Department
1	1-11-2022 16:00	10-11-2022 10:11		A
1	10-11-2022 10:11			B
2	2-11-2022 15:35	3-11-2022 13:34	3-11-2022 13:34	A
3	1-11-2022 09:15	2-11-2022 10:24		A
3	2-11-2022 10:24	3-11-2022 18:12	3-11-2022 18:12	C

So you can see that reference 1 transfer from department A to B at 10-11-2022 10:11. 

Reference 2 is discharged out of the hospital direct from department A.

Reference 3 transfers to department C and gets discharged out of that department (I don't want to know that discharge, only the report of department A to witch department the patient is transferd or discharged).

The file contains every department in the hospital.

Hope some can make the measure because with my knowledge... 🙂

[bdeleur]

The discharge out of hospital is only relevant when there is no next department. Then "discharge" needs to count as an movement, but only for the last deparment for that patient.

Every transfer needs to be counted, even they move back to a department

[andhiii079845]

Perhaps try @tamerj1 solution if it works what you looking for. 🙂 
If not, let us know. 

[andhiii079845]

Hi, 
can you please give more information what the measure should count exactly:
Tranfer of patient from A,B,C, to A,B,C? Like a matrix? 

From / to	A	B	C
A	1	4
B	2	....
C	3	....

[bdeleur]

Hi,

I really like the idea of the matrix. Didn't think about that. So I would like tot see that.

From there I think it is easy to filter for every department.

Is that possible?