Line chart with item status

amitchandak , thank you very much for sharing. So far, I didn't make it work, but I need to put some more time into it.

Anonymous , thank you very much! It is almost what I would like to achieve, but for now the calculation doesn't work. For example, if you look at the items with a create date of 1-1-2020 (1 January 2020, dd-mm-yyyy):

ItemNo CreateDate DueDate CloseDate
1 1-1-2020 1-4-2020 31-3-2020
2 1-1-2020 1-4-2020 31-3-2020
3 1-1-2020 1-4-2020 1-6-2020
4 1-1-2020 1-4-2020 1-6-2020
5 1-1-2020 1-5-2020 1-6-2020
6 1-1-2020 1-6-2020 31-5-2020
7 1-1-2020 31-12-2020
8 1-1-2020 31-12-2020
9 1-1-2020 31-12-2020

On 1-1-2020 there are 9 open items. 2 are closed on 31-3-2020, so on that date there are 7 open items. On 1-4-2020 4 items are overdue, of which 2 are closed. So on 1-4-2020 there are 7 open items, of which 2 are overdue. And on 1-5-2020 there are 7 open items, of which 3 are overdue.

Thanks again,

Frank

Ashish_Mathur , thank you for you message.

# of Open Items = # ItemNo where ItemTable[CloseDate] > Calendar[Date]

# of Overdue Items = # Open Items where ItemTable[DueDate] < Calendar[Date]

Kind regards