I would like to have some support regarding the calculation of network days from a single column of date field and then I need to calculate the average of network days.
Average of network days is relatively easier as I need to use ‘groupby’ node. I would like to understand how can I calculate network days from single column per consultant as shown in image.
The numbers you provided seem off by 1 when I did a manual check. If you require the numbers to be off by 1, i.e. to not take into account the day seen, you can add the Math Formula node ($patient_network_days$ - 1) to this new workflow: