Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Can you please provide your sample data in excel file?
try using rangesum()