Hi @xyz27
sorry for the late reply.
I think it is not possible to receive this outcome from your data how it is.
To solve this you need to pre calculate it with other tools or change the data source. You would need a additional calender table and cross join it.
Best regards,
Nico