I currently have data of users and their associated segment at specific points of time. Data looks something like this (sorry I can’t put more than 1 pic)
User ID; Time; Category
1; July; Segment A
1; August; Segment A
2; July; Segment A
2; August; Segment B
For example, User 2 can change his/her status from Segment A to Segment B from July to August.
What I am trying to achieve is the percentages of users from each Segment converted to other Segments by time. It should look like this.
So far I haven’t found a way to build something like that.
Would really appreciate helps and inputs from you guys. Thanks!