Hello
everybody, I ve been searching for quite some time now but I cant find anything that fits my Use case.
It is a complicated one so bear with me. Thanks.
So I want to create a dataset, which has every day of an interval, for example if it is one year, I need 365 rows.
Every row should have the count of the according tasks that are still active on that date.
At a later stage I want to aggreggate the values per date till it reaches 100%.
Example:
Input:
ID Start Date Finish Date Duration
01 01.01.2019 10.01.2019 10
02 03.01.2019 10.01.2019 7
03 05.01.2019 08.01.2019 3
04 08.01.2019 11.01.2019 3
Expected Output:
Date Count Percent
01.01 1 1
02.01 1 2
03.01 2 4
...
10.01 3
11.01 1
The problem I encounter is that there is no easy way to create a For Loop like for example in Java.
In short the use case is to create as many rows from max(Finish Date) - min(Start date) + 1 (inklusive), in the example 11.01 - 01.01 + 1 = 11days.
Thanks again
