Icon

justKnimeit-20

justKnimeit-20
Challenge 20: Patient Network DaysDescription: You work for a hospital and they have data for each time a patient was seen. In this challenge, youwill calculate the difference between each time a patient was seen excluding weekends (called "network days").Once you calculate the network days, calculate the average network days per patient. For the challenge,experiment with the input and output below. Patient DataConvert to DateRank by Nameand DateSort by Nameand DateLag for Datefor 1 rowIdentifyfirst visitCalculateWorking DaysBetweenCalculate PatientMeansResults Table Creator String to Date&Time Rank Sorter Lag Column Column Expressions Java Snippet GroupBy Joiner RowID Challenge 20: Patient Network DaysDescription: You work for a hospital and they have data for each time a patient was seen. In this challenge, youwill calculate the difference between each time a patient was seen excluding weekends (called "network days").Once you calculate the network days, calculate the average network days per patient. For the challenge,experiment with the input and output below. Patient DataConvert to DateRank by Nameand DateSort by Nameand DateLag for Datefor 1 rowIdentifyfirst visitCalculateWorking DaysBetweenCalculate PatientMeansResults Table Creator String to Date&Time Rank Sorter Lag Column Column Expressions Java Snippet GroupBy Joiner RowID

Nodes

Extensions

Links