Hi,
How can I bring over my capacity column to every business day? but my capacity is only given in weeks.
please see attached workflow.
expected output:
Name | Dates | capacity |
Louis | 2023_01_02 | 0.740181 |
Louis | 2023_01_03 | 0.740181 |
Louis | 2023_01_04 | 0.740181 |
Louis | 2023_01_05 | 0.740181 |
Louis | 2023_01_06 | 0.740181 |
Louis | 2023_01_09 | 0.940181 |
Louis | 2023_01_10 | 0.940181 |
Louis | 2023_01_11 | 0.940181 |
Louis | 2023_01_12 | 0.940181 |
Louis | 2023_01_13 | 0.940181 |
Louis | 2023_01_16 | 0.940181 |
Louis | 2023_01_17 | 0.940181 |
Louis | 2023_01_18 | 0.940181 |
Louis | 2023_01_19 | 0.940181 |
Louis | 2023_01_20 | 0.940181 |
Louis | 2023_01_23 | 0.940181 |
Louis | 2023_01_24 | 0.940181 |
Louis | 2023_01_25 | 0.940181 |
Louis | 2023_01_26 | 0.940181 |
Louis | 2023_01_27 | 0.940181 |
Louis | 2023_01_30 | 0.940181 |
Louis | 2023_01_31 | 0.940181 |
Louis | 2023_02_01 | 0.940181 |
Louis | 2023_02_02 | 0.940181 |
Louis | 2023_02_03 | 0.940181 |
Louis | 2023_02_06 | 0.940181 |
Louis | 2023_02_07 | 0.940181 |
Louis | 2023_02_08 | 0.940181 |
Louis | 2023_02_09 | 0.940181 |
Louis | 2023_02_10 | 0.940181 |
Louis | 2023_02_13 | 0 |
Louis | 2023_02_14 | 0 |
Louis | 2023_02_15 | 0 |
Louis | 2023_02_16 | 0 |
Louis | 2023_02_17 | 0 |
Louis | 2023_02_20 | 0.504887 |
Louis | 2023_02_21 | 0.504887 |
Louis | 2023_02_22 | 0.504887 |
Louis | 2023_02_23 | 0.504887 |
Louis | 2023_02_24 | 0.504887 |
Louis | 2023_02_27 | 0.940181 |
Louis | 2023_02_28 | 0.940181 |
Solved! Go to Solution.
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |