Forum Discussion

PareshDalvi's avatar
PareshDalvi
Frequent Visitor
3 years ago

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

 

 

Need Help

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    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