Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I feel like this should be simple but just can't figure out the right approach. I have calculated a running total per rank (not using dates but sprints in an Agile project) successfully. However I would now like to calculate the running total for completed or "Done" i.e. by status.
I think for step one I need to calculate the total points per Sprint filtered by "Done" status as a calculated column probably using the calculate function. I have tried the following from other forums:
Points | Sprint | Sprint total WPs | Completed points |
4.7 | 0 | 994.45 | 628 |
4 | 0 | 994.45 | 628 |
2.7 | 0 | 994.45 | 628 |
1.35 | 0 | 994.45 | 628 |
5.4 | 1 | 9.5 | 628 |
3.1 | 1 | 9.5 | 628 |
1 | 1 | 9.5 | 628 |
3.4 | 2 | 12.4 | 628 |
2 | 12.4 | 628 | |
4 | 2 | 12.4 | 628 |
4 | 2 | 12.4 | 628 |
1 | 2 | 12.4 | 628 |
3 | 4.7 | 628 | |
1 | 3 | 4.7 | 628 |
0.5 | 3 | 4.7 |
Would love some help!
thanks
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |