I want capture the cummulative sum of say Passed values between 2 dates (where one is in dimension) in expression
For eg: day 1: sum(passed) w.r.t latest excecuted time
day2: sum of passed for day 1 as well as day2 w.r.t latest excecuted time
day3: sum of passed of day1, day 2, day3 w.r.t latest excecuted time
In aggregation I want give inbetween function of those 2 dates
Sample: Input data
| test case | 1.4 | 2.4 | 3.4 | 4.4 | 5.4 | 6.4 | 7.4 |
| a | passed |
| passed | failed | passed |
|
|
| failed | passed |
| b |
|
| passed |
|
|
| failed |
| failed | passed |
| c |
| passed | failed |
| passed | passed |
|
| passed | failed |
| d | passed |
|
|
|
|
|
| skipped |
|
|
| e |
|
| failed | failed | passed | passed |
| failed |
|
|
| f | skipped |
|
|
| passed | passed |
|
|
|
|
| g | passed |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Required Output:
| Day | passed | failed | skipped |
| 7.4 | 4 | 2 | 1 |
| 6.4 | 4 | 2 | 1 |
| 5.4 | 6 |
| 1 |
| 4.4 | 7 |
|
|
| 3.4 | 3 | 3 | 1 |
| 2.4 | 4 | 2 | 1 |
| 1.4 | 4 |
| 1 |
