
1. Re: Counting transitions from one state to another
Norbert Maijoor Jan 25, 2017 11:20 AM (in response to Ivan Rankenburg)Hi Ivan,
Find my approach based on LOD expression and Quick Calculation "Difference" as reference below and stored in attached workbook version 9.3
Count: {fixed [Spend Level],[Date]:count([UserID])}
Transition: Count > Quick Calculation "Difference"

Difference.twbx 10.5 KB


2. Re: Counting transitions from one state to another
Ivan Rankenburg Jan 25, 2017 11:29 AM (in response to Norbert Maijoor)Close... You can count, daily, how many users are at each level, and you can count the change in the number of users, but this is not entirely what I need.
According to your result, if A has 100 people in it on a given day, and 100 people in it the following day, you might conclude nobody joined or left level A. Whereas in actuality, perhaps 10 people left level A and 10 people joined level A. For example, according to your output, it appears nothing changed on the 4th and 5th, whereas in actuality, a lot changed.
Each day, I need the complete matrix of transitions. I need to know how many joined A (and where they came from), and how many people left A (and where they went to).
Thanks for your attention!