Cummulative Count
Hi Community I need your help! I have the following scenario: I have a list of tasks that are related to a sprint. In this tabele ALL tasks (active and closed) are listed. For each Task ID I have the following collumns. The collumn "Active Date" presents the day on which a task was in the state "Active". The collumn "Closed Date" represents the day on which a task was in the state "Closed/Compleded". Now, what I'd like to do is to show in a visual the cummulative count of active and closed/completed tasks during the days of one selected Sprint. For the sprint of calendar week 43 the visual should look similar to picture 1. I now that I need two different measures (one for the cummulative count of the tasks that are "active", and one for those that are "compleded") however the difficulty is that it should only cummulatively count the respective tasks based on the selected Sprint Week in the Filter. This means that with each start of a new sprint the measure begins to count from 0 and does not include the previous sprints into the calculation. I've tried to make it more clear with table 2. I hope that you guys can help me! Thank you in advance! Here is some sample data: Task ID Sprint CW Sprint Start Date Sprint End Date Activated Date Completed Date 1 41-42 08.10.2022 22.10.2022 05.10.2022 20.10.2022 2 41-42 08.10.2022 22.10.2022 06.10.2022 10.10.2022 3 41-42 08.10.2022 22.10.2022 06.10.2022 11.10.2022 4 41-42 08.10.2022 22.10.2022 06.10.2022 20.10.2022 5 41-42 08.10.2022 22.10.2022 06.10.2022 25.10.2022 6 41-42 08.10.2022 22.10.2022 07.10.2022 10.10.2022 7 41-42 08.10.2022 22.10.2022 07.10.2022 20.10.2022 8 41-42 08.10.2022 22.10.2022 12.08.2022 19.10.2022 9 41-42 08.10.2022 22.10.2022 12.08.2022 19.10.2022 10 41-42 08.10.2022 22.10.2022 12.10.2022 12.10.2022 11 41-42 08.10.2022 22.10.2022 13.10.2022 17.10.2022 12 41-42 08.10.2022 22.10.2022 14.08.2022 null 13 41-42 08.10.2022 22.10.2022 14.10.2022 21.10.2022 14 41-42 08.10.2022 22.10.2022 16.09.2022 20.10.2022 15 41-42 08.10.2022 22.10.2022 18.10.2022 18.10.2022 16 41-42 08.10.2022 22.10.2022 19.08.2022 10.10.2022 17 41-42 08.10.2022 22.10.2022 19.10.2022 20.10.2022 18 41-42 08.10.2022 22.10.2022 20.09.2022 20.10.2022 19 41-42 08.10.2022 22.10.2022 20.10.2022 21.10.2022 20 41-42 08.10.2022 22.10.2022 20.10.2022 21.10.2022 21 41-42 08.10.2022 22.10.2022 20.10.2022 21.10.2022 22 41-42 08.10.2022 22.10.2022 20.10.2022 25.10.2022 23 41-42 08.10.2022 22.10.2022 20.10.2022 21.10.2022 24 41-42 08.10.2022 22.10.2022 21.10.2022 21.10.2022 25 41-42 08.10.2022 22.10.2022 23.09.2022 20.10.2022 26 41-42 08.10.2022 22.10.2022 27.05.2022 20.10.2022 27 41-42 08.10.2022 22.10.2022 28.06.2022 20.10.2022 28 43-44 22.10.2022 05.11.2022 01.07.2022 null 29 43-44 22.10.2022 05.11.2022 03.10.2022 25.10.2022 30 43-44 22.10.2022 05.11.2022 04.10.2022 null 31 43-44 22.10.2022 05.11.2022 06.10.2022 25.10.2022 32 43-44 22.10.2022 05.11.2022 07.10.2022 null 33 43-44 22.10.2022 05.11.2022 11.08.2022 null 34 43-44 22.10.2022 05.11.2022 11.10.2022 null 35 43-44 22.10.2022 05.11.2022 11.10.2022 null 36 43-44 22.10.2022 05.11.2022 11.10.2022 null 37 43-44 22.10.2022 05.11.2022 11.10.2022 null 38 43-44 22.10.2022 05.11.2022 12.10.2022 null 39 43-44 22.10.2022 05.11.2022 12.10.2022 null 40 43-44 22.10.2022 05.11.2022 12.10.2022 null 41 43-44 22.10.2022 05.11.2022 12.10.2022 null 42 43-44 22.10.2022 05.11.2022 12.10.2022 null 43 43-44 22.10.2022 05.11.2022 12.10.2022 null 44 43-44 22.10.2022 05.11.2022 12.10.2022 null 45 43-44 22.10.2022 05.11.2022 12.10.2022 null 46 43-44 22.10.2022 05.11.2022 12.10.2022 null 47 43-44 22.10.2022 05.11.2022 12.10.2022 null 48 43-44 22.10.2022 05.11.2022 12.10.2022 null 49 43-44 22.10.2022 05.11.2022 12.10.2022 null 50 43-44 22.10.2022 05.11.2022 12.10.2022 null 51 43-44 22.10.2022 05.11.2022 12.10.2022 null 52 43-44 22.10.2022 05.11.2022 12.10.2022 null 53 43-44 22.10.2022 05.11.2022 13.10.2022 27.10.2022 54 43-44 22.10.2022 05.11.2022 14.10.2022 null
