Forum Discussion
ddorhout
2 years agoFrequent Visitor
Process phases grouping and visualization
Dear Forum, I am running into an issue. I would like to have process phases visualized for each product that is going through those phases. I have the status of the lowel level phases, but I wan...
- 2 years ago
ddorhout I have attached the solution, please tweak it as you see fit. There are two parts to this solution: 1) preparing the data in PQ to optimize the model and 2) measure to visualize the data at different granularities.
Cheers!!
ddorhout
2 years agoFrequent Visitor
The solution is working as a charm. However, now I am facing the next issue: how do I add another state such as "Not Needed"? Now, when not everything is on "Yes", it gives "In progress". However, how do I make sure the "Not needed"s are excluded from this "In progress" calculation. I am struggling with PowerQuery.