Create decomposition based on grouped data

[PareshDalvi]

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 application.

In following sample data, a user journey is shown. I would like to see, how many users went through this journey. 

e.g.

FirstAction -  User selected home,

Second Action - User ran script,

third action - Script returned Normal latency

and so on.....

[BA_Pete]

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