Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts
I need to calculate how many Projects of each company moved from Phase 1 to Phase 3 as a Percentage. See sample dats below
in the explain below for company ABC Phase 1 = 17 Projects and Phase 2 = 8 Projects hence 47 of the applications moved to the second phase ie. Phase 2 , then 2 out of 8 projects move to final phase 3 = 25%.
Co Name | Phase 1 | Phase 2 | Phase 3 |
ABC | 17 | 8 | 2 |
SSF | 16 | 11 | 4 |
DDCW | 11 | 9 | 5 |
Solved! Go to Solution.
Hi,
i'm unsure on the explanation are you just looking for the calculation to work out between phase 2 and 3 to give you the 25% figure:
if so
Hi,
i'm unsure on the explanation are you just looking for the calculation to work out between phase 2 and 3 to give you the 25% figure:
if so
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |