Icon

justknimeit-20

justknimeit-20
Just KNIME It!Challenge 20: Patient Network DaysLevel: HardDescription: You work for a hospital and they have data for each time a patient was seen. In this challenge, you will calculate the difference between each time apatient was seen excluding weekends (called "network days"). Once you calculate the network days, calculate the average network days per patient. For thechallenge, experiment with the input and output below. DataDay of weekDatedate diffDay of weekPatientTo missing if patient name does not matchMeanMeanCalculate Correction DaysCalculate Network Days1.Patient2.Date Table Creator String to Date&Time Extract Date&TimeFields Lag Column Date&TimeDifference Lag Column Lag Column Rule Engine GroupBy Joiner Column Rename Rule Engine Math Formula Sorter Just KNIME It!Challenge 20: Patient Network DaysLevel: HardDescription: You work for a hospital and they have data for each time a patient was seen. In this challenge, you will calculate the difference between each time apatient was seen excluding weekends (called "network days"). Once you calculate the network days, calculate the average network days per patient. For thechallenge, experiment with the input and output below. DataDay of weekDatedate diffDay of weekPatientTo missing if patient name does not matchMeanMeanCalculate Correction DaysCalculate Network Days1.Patient2.Date Table Creator String to Date&Time Extract Date&TimeFields Lag Column Date&TimeDifference Lag Column Lag Column Rule Engine GroupBy Joiner Column Rename Rule Engine Math Formula Sorter

Nodes

Extensions

Links