Forum Discussion
Create decomposition based on grouped data
Hi All, I've AppInsights data that tracks users actions in an application. I would like to group the actions by sessionID and create a decomposition tree that shows how users interact with the ap...
Hi PareshDalvi ,
If you only want to track a few actions, I would do the following:
Select [Events.Decomposition]. Go to Transform tab > Pivot Column. Select [Events.Timestamp] as your Values.
Rename your new columns to more friendly (shorter) names.
Apply to the model and create the following measure:
_noofActions = COUNTROWS(yourTableName)
Use this measure and each of your new columns to build the decomp chart.
Pete