The next thing to do is configure a total count of records line to build the scope of cards yet to be completed. We need to have a criterion, like the iteration tag of the card we need to analyze, or the name of your ''Backlog'' list with items completed before the selected date range in order to exclude them. In this example, we'll just exclude cards from the list named Backlog
.
Click the "+" sign on the Y axis, and then provide the total scope calculation. In our case, it looks like this: COUNTIF_DISTINCT([Card Id],NOT(LIKE([List], '%Backlog%')) AND NOT(LIKE([List], '%Done%') and [Date] < [Timeline Start]))
. In this example, the total scope of cards to be done is formed from all cards which are not in the backlog and were not completed before the start of the selected date range.