Forum Discussion
How to create decomposition tree from different process steps in one column
Hi Community,
I am having trouble creating a decomposition tree for an event logger dataset, that has all event steps in one column.
The data looks like this:
What I want to accomplish is a transformation to make the data look like this:
Because then I could use PowerBI's decomposition tree to show the performance of our process (in this case a chatbot that allows a customer to change his/her email adress):
My goal is only this decomposition tree, so if I can do it without previous data transformation, I would be fine.
But also I dont know how to perform the data transformation (2nd screenshot) in PowerBI.
Thanks for any kind of help 🙂
Hi Anonymous ,
Here are the steps you can follow：
1. In Power Query -- Add Column – Index Column – From.
2. Transform – Group -- [User ID]– Operation：All Rows.
3. Add Column – Custom Column – Enter the following code.
Table.AddIndexColumn([Count],"Rank",1,1)
4. Selected [Count] – Remove.
5. Expand [Custom] - Do not select column [User ID] - OK.
6. Select [Custom.Timestramp] , [Custom.Index] – Remove Columns.
7. Select [Merged] and [Custom.Rank] -- Transform – Pivot Column.
Value Column -- [Custom.Process Step Logging].
Advanced options – Don’t Aggregate.
8. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi Anonymous ,
Here are the steps you can follow：
1. In Power Query -- Add Column – Index Column – From.
2. Transform – Group -- [User ID]– Operation：All Rows.
3. Add Column – Custom Column – Enter the following code.
Table.AddIndexColumn([Count],"Rank",1,1)
4. Selected [Count] – Remove.
5. Expand [Custom] - Do not select column [User ID] - OK.
6. Select [Custom.Timestramp] , [Custom.Index] – Remove Columns.
7. Select [Merged] and [Custom.Rank] -- Transform – Pivot Column.
Value Column -- [Custom.Process Step Logging].
Advanced options – Don’t Aggregate.
8. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly